FrontAccounting forum — Uploading a new database script- error

Re: Uploading a new database script- error

2010-05-20T00:21:53Z

Ok, I did what I was supposed to do before asking, and I found out for the taz groups.

Gaston

Re: Uploading a new database script- error

2010-05-19T23:59:49Z

Ok, I reinstalled. The way I did it is by moving "French - Canada - General downloads: 86 | type: zip | size: 9 kB" sql to the backup directory and then restoring the database with the backup and restore tool.

Everything works well so far, with one exception: I am not allowed to create a supplier because:
"There are no tax groups defined in the system. At least one tax group is required before proceeding." says the message.

Question: why is my Tax groups in grey (not active). How can I create a group ?

Thanks,

Gaston

Re: Uploading a new database script- error

2010-05-19T21:31:03Z

Hello

The installed database is the one, yes.

But I was under the impression that executing the script has the effect of dropping all the table anyways, doing in the fact a reinstall ?

I don't think it is such a big deal for me to just reinstall the "company" from scratch using the french canadian mostly translated sql chart.

If you don't see anything wrong with the above messages, I will then reinstall and keep you posted.

Thanks

Gaston

Re: Uploading a new database script- error

2010-05-19T20:47:35Z

Just out of interest, is this the database on which you did that fairly innovative deletion of financial data? If it is, could you do a backup and then re-install the FrontAccounts system and see if it then works correctly.

Re: Uploading a new database script- error

2010-05-19T16:45:51Z

Hello

That one from FA site:

French - Canada - General downloads: 86 | type: zip | size: 9 kB
This is a French Canadian chart of accounts for a starting company. After creating a new company with this chart, please check/create a new fiscal year and change the company data to suit your needs.
This chart needs some minor translations in other tables, but the chart is complete.

Complete information from the diagnostic page:

Test Test type Value Comments
MySQL version >3.23.58 Required 5.1.30-community Ok
PHP version >4.3.2 Required 5.2.8 Ok
Http server type Info Microsoft-IIS/7.0 Ok
Server system Info WINNT Ok
Browser type Info Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.38 Safari/533.4 Ok
Native gettext Optional No Ok
Debugging mode Info Yes Ok
Error logging Recomended C:\Data\SitesWeb\rimqfa/tmp/errors.log Ok
Current database version Required 2.2 Ok
Company subdirectories consistency Required ../company/*
../company/*/images
../company/*/pdf_files
../company/*/backup
../company/*/js_cache Ok
Language configuration consistency Required en_GB
fr_FR Missing system locale: fr_FR.ISO-8859-1
Temporary directory Required ../tmp Ok
Session save path Info C:\Windows\Temp Ok
Database auth file Recomended ../config_db.php '../config_db.php' file should be read-only if you do not plan to add or change companies
Main config file Recomended ../config.php '../config.php' file should be read-only
Extensions configuration files Required ../installed_extensions.php Ok

Re: Uploading a new database script- error

2010-05-19T15:05:11Z

Which new database script are you running? What's the path for your temp directory?

Re: Uploading a new database script- error

2010-05-19T12:45:34Z

Hello

Here are line lines not "Ok" after looking at the diagnostic page:

Language configuration consistency Required en_GB
fr_FR Missing system locale: fr_FR.ISO-8859-1
Database auth file Recomended ../config_db.php '../config_db.php' file should be read-only if you do not plan to add or change companies
Main config file Recomended ../config.php '../config.php' file should be read-only

Also got these messages:
Use of undefined constant LC_MESSAGES - assumed 'LC_MESSAGES' in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 218
setlocale() [function.setlocale]: Passing locale category name as string is deprecated. Use the LC_* -constants instead in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 218
setlocale() [function.setlocale]: Invalid locale category name LC_MESSAGES, must be one of LC_ALL, LC_COLLATE, LC_CTYPE, LC_MONETARY, LC_NUMERIC, or LC_TIME in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 218
Use of undefined constant LC_MESSAGES - assumed 'LC_MESSAGES' in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 233
setlocale() [function.setlocale]: Passing locale category name as string is deprecated. Use the LC_* -constants instead in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 233
setlocale() [function.setlocale]: Invalid locale category name LC_MESSAGES, must be one of LC_ALL, LC_COLLATE, LC_CTYPE, LC_MONETARY, LC_NUMERIC, or LC_TIME in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 233
Use of undefined constant LC_MESSAGES - assumed 'LC_MESSAGES' in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 240
setlocale() [function.setlocale]: Passing locale category name as string is deprecated. Use the LC_* -constants instead in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 240
setlocale() [function.setlocale]: Invalid locale category name LC_MESSAGES, must be one of LC_ALL, LC_COLLATE, LC_CTYPE, LC_MONETARY, LC_NUMERIC, or LC_TIME in file: C:\Data\SitesWeb\rimqfa\admin\system_diagnostics.php at line 240

Re: Uploading a new database script- error

2010-05-19T10:57:19Z

Looks like a permissions problem. It would appear that your web server only allows files to be saved and opened above the server document root - perhaps because PHP is running in safe mode? Use company 0 to check your configuration (on the setup menu).

Uploading a new database script- error

2010-05-19T09:43:21Z

When trying to modify my company with a new database script, I got the following messages:

file() [function.file]: open_basedir restriction in effect. File(C:\tmp\phpUpload\phpF1E3.tmp) is not within the allowed path(s): (C:\Data\SitesWeb) in file: C:\Data\SitesWeb\rimqfa\admin\db\maintenance_db.inc at line 342
file(C:\tmp\phpUpload\phpF1E3.tmp) [function.file]: failed to open stream: Operation not permitted in file: C:\Data\SitesWeb\rimqfa\admin\db\maintenance_db.inc at line 342
Invalid argument supplied for foreach() in file: C:\Data\SitesWeb\rimqfa\admin\db\maintenance_db.inc at line 346

I.m running in a windws environment.

Thanks for helping me.

Gaston