• From: Canada, QC, Montreal
  • Registered: 05/16/2010
  • Posts: 167

Topic: Uploading a new database script- error

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

  • From: UK, Scotland, Aberdeen
  • Registered: 04/21/2010
  • Posts: 30

Re: Uploading a new database script- error

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).

W

  • From: Canada, QC, Montreal
  • Registered: 05/16/2010
  • Posts: 167

Re: Uploading a new database script- error

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

  • From: UK, Scotland, Aberdeen
  • Registered: 04/21/2010
  • Posts: 30

Re: Uploading a new database script- error

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

  • From: Canada, QC, Montreal
  • Registered: 05/16/2010
  • Posts: 167

Re: Uploading a new database script- error

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

  • From: UK, Scotland, Aberdeen
  • Registered: 04/21/2010
  • Posts: 30

Re: Uploading a new database script- error

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.

W

  • From: Canada, QC, Montreal
  • Registered: 05/16/2010
  • Posts: 167

Re: Uploading a new database script- error

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

8 Reply by huotg01 (edited by huotg01 05/20/2010 12:00:40 am)

  • From: Canada, QC, Montreal
  • Registered: 05/16/2010
  • Posts: 167

Re: Uploading a new database script- error

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

  • From: Canada, QC, Montreal
  • Registered: 05/16/2010
  • Posts: 167

Re: Uploading a new database script- error

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

Gaston