Invoice 1.1 installation issue

[fredimac]

Greetings,

 

The instructions for Invoice 1.1 on step 10 indicate that I should:

 

10.) Execute the statements in the file ei_sql.sql to your MySql Server in order to setup the Email Options administration values

 

When I go to phpMyAdmin, click Catalog > SQL > browse to ei_sql.sql and click GO, I get the following error:

 

MySQL said:

 

 

You have an error in your SQL syntax near 'INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , ' at line 3

 

 

Ideas?

 

Thanks in Advance,

Fred

[OceanRanch]

Sounds like the ei_sql.sql file either has a bug in it, or your version got corrupted when you unzipped it.

 

Post the ei_sql.sql file for folks to look at or if you see the error on line 3 fix it, or try re-downloading and unzipping locally, then ftp to your site. Sometimes end-of-line characters can be a pain.....

 

HTH

Tom

[fredimac]

Post of SQL File ei_sql.sql. I'm not sure how to keep the syntax.

----------------------------------------------------

 

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )

VALUES (

'', 'Email Invoice to Customer', 'EMAIL_INVOICE', 'true', 'If this flag is enabled, the HTML invoice of the order will be sent to the customer.', '12', '0', NULL , NOW( ) , '', ''

)

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Default Email Template File', 'EMAIL_TEMPLATE_FILE', 'invoice.php', 'This value dictates which template file will be used when sending the email.', 12, 0, NULL, NOW(), '', '');

 

 

Sounds like the ei_sql.sql  file either has a bug in it, or your version got corrupted when you unzipped it.

 

Post the ei_sql.sql  file for folks to look at or if you see the error on line 3 fix it, or try re-downloading and unzipping locally, then ftp to your site. Sometimes end-of-line characters can be a pain.....

 

HTH

Tom

<{POST_SNAPBACK}>

[OceanRanch]

Looks like you did not include a configuration_id.

 

VALUES (

'', 'Email Invoice to Customer', 'EMAIL_INVOICE', 'true', 'If this flag is enabled, the HTML invoice of the order will be sent to the customer.', '12', '0', NULL , NOW( ) , '', ''

)

 

should be

 

VALUES (

'999', 'Email Invoice to Customer', 'EMAIL_INVOICE', 'true', 'If this flag is enabled, the HTML invoice of the order will be sent to the customer.', '12', '0', NULL , NOW( ) , '', ''

)

 

The 999 or whatever the contribution readme file suggests. If not, then you'll need to find out via phpmyadmin in the configuration table which id you could use.

 

HTH

Tom

[fredimac]

The readme does not contain any instructions.

 

What is that Value parameter referencing? I'm new to this SQL / PHP stuff. I don't know what to look for in phpMyAdmin.

 

Thanks,

Fred

 

Looks like you did not include a configuration_id.

 

VALUES (

'', 'Email Invoice to Customer', 'EMAIL_INVOICE', 'true', 'If this flag is enabled, the HTML invoice of the order will be sent to the customer.', '12', '0', NULL , NOW( ) , '', ''

)

 

should be

 

VALUES (

'999', 'Email Invoice to Customer', 'EMAIL_INVOICE', 'true', 'If this flag is enabled, the HTML invoice of the order will be sent to the customer.', '12', '0', NULL , NOW( ) , '', ''

)

 

The 999 or whatever the contribution readme file suggests. If not, then you'll need to find out via phpmyadmin in the configuration table which id you could use.

 

HTH

Tom

<{POST_SNAPBACK}>

[fredimac]

Ideas anyone? I still don't quite get it.

 

Thanks,

Fred

 

The readme does not contain any instructions.

 

What is that Value parameter referencing?  I'm new to this SQL  / PHP stuff.  I don't know what to look for in phpMyAdmin.

 

Thanks,

Fred

<{POST_SNAPBACK}>

[OceanRanch]

Hi Fred,

 

Contributions can store information in your "configuration" table so that they can retrieve things like "Send mail using HTML" and whether its true or false.

 

These values are stored with a contribution configuration_id number that is normally defined by the contribution. Numbers are not assigned because there are literally thousands of contributions and duplicate numbers can cause problems.

 

Using the phpmyadmin tool you can browse the configuration table and determine if a configuration_id is in use by another contribution. Pick a number that is not there and use it the sql command that failed to properly insert the option in your database.

 

If you don't know how to use phpmyadmin, go to the phpmyadmin web site and take a short tutorial on it features and how to use.

 

If that's too complex, then maybe you should consider sticking with the basic oscommerce store with no contributions, or hire a programmer to help you thru the more complex issues. Or continue posting and trudging thru all this stuff and learn alot like most everyone here on the forum.

 

 

HTH

Tom

Edited June 28, 2005 by OceanRanch