Hello,
I'm using osCommerce Online Merchant v2.2 RCI where I installed the FCKeditor, plus the newsletter addon. The installation seemed to be successfull until I tried to send a newsletter, I received the following error message:
But I did create that table, as far as I know anyway. Unfortunately, I'm not the that good in SQL and PHP to be able to solve the problem. Maybe someone could help, that would be great, thank you.
I'm using osCommerce Online Merchant v2.2 RCI where I installed the FCKeditor, plus the newsletter addon. The installation seemed to be successfull until I tried to send a newsletter, I received the following error message:
1146 - Table '************.TABLE_CUSTOMERS_TEMP' doesn't exist
select * from TABLE_CUSTOMERS_TEMP
[TEP STOP]
But I did create that table, as far as I know anyway. Unfortunately, I'm not the that good in SQL and PHP to be able to solve the problem. Maybe someone could help, that would be great, thank you.
Re: Table Customer Temp doesn't exist
Re: Table Customer Temp doesn't exist
You might have better luck asking in a osCommerce Online Merchant forum.
Re: Table Customer Temp doesn't exist
CREATE TABLE `customers_temp` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_firstname` varchar(32) NOT NULL default '',
`customers_lastname` varchar(32) NOT NULL default '',
`customers_email_address` varchar(96) NOT NULL default '',
PRIMARY KEY (`customers_id`)
) TYPE=MyISAM ;
yet the query looks for a table called Table_Customer_Temp
To fix it delete or drop the table 'customers_temp'using phpmyadmin and then run this sql instead and everything else will work.
CREATE TABLE `table_customers_temp` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_firstname` varchar(32) NOT NULL default '',
`customers_lastname` varchar(32) NOT NULL default '',
`customers_email_address` varchar(96) NOT NULL default '',
PRIMARY KEY (`customers_id`)
) TYPE=MyISAM ;
Thanks Martin Leeney itscoldoutside.com
Re: Table Customer Temp doesn't exist
The suggested solution "CREATE TABLE `table_customers_temp`" doesn't work.
Thanks
David