3 replies to this topic

[B-Tronix]

(setting up a new Shop from scratch wits osC 2.2ms2)
Hi Guys,

First I tried to use the original "zones.php" that comes with the installation package,
in the next step I tried this contrib: http://www.oscommerce.com/community/contributions,920
replacing the original "zones.php".

In both cases (original and modified "zones.php") I get the same error message, when I modify the line "$this->num_zones = 1" for example to the number of "4" (to have 4 shipping-zones)

The error message shows up up, when I deinstalled the module (in admin), then chage the numper of zones in the php file, save the php-file, and then clicking on the Install-Button again.

The error message is as follows:

Quote

1064 - You have an error in your SQL syntax near 'True', 'False'), ', now())' at line 1

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())

[TEP STOP]

my Server Configuration is: _____________________

Server Information:
Server OS: Linux 2.4.27
Database: MySQL 3.23.57-log
Server Date: 01.06.2005 20:19:57
Database Date: 01.06.2005 20:19:57
Server Up Time:
HTTP Server: Apache/df-exts 1.1 (Unix) mod_ssl/2.8.19 OpenSSL/0.9.6k AuthPG/1.3 FrontPage/5.0.2.2510
PHP Version: 4.3.10 (Zend: 1.3.0)

Can anyone help me, please ?

[B-Tronix]

The Problem is solved !

You should not use the onboard osCommerce editor (filemanager).
This tool doesnt work correct !!
any changing of any php-file has to be made on you local PC with a good text-editor-program !

[dirthawker]

B-Tronix, on Jan 7 2005, 09:56 AM, said:

The Problem is solved !

You should not use the onboard osCommerce editor (filemanager).
This tool doesnt work correct !!
any changing of any php-file has to be made on you local PC with a good text-editor-program !

<{POST_SNAPBACK}>

About the editor, yes, a lot of people have said that.

I looked at your message just now and thought that in

'tep_cfg_select_option(array('True', 'False'), ', now())

That single quote between commas was probably what tripped it. It's unnatural to have a single quote like that. Was that it?

Edited by dirthawker, 08 January 2005, 04:53.

[B-Tronix]

dirthawker, on Jan 8 2005, 05:50 AM, said:

About the editor, yes, a lot of people have said that.

I looked at your message just now and thought that in

'tep_cfg_select_option(array('True', 'False'), ', now())

That single quote between commas was probably what tripped it.  It's unnatural to have a single quote like that.  Was that it?

<{POST_SNAPBACK}>

No,
everything is on the right place regarding the syntax.

As I said,
as soon as I use the onboard osCommerce editor (filemanager)
for editing any php-file,
almost none of them will execute correctly anymore...