Help! How to insert the new tables found in the affiliate.sql file ?

[vivaspark]

Any one can teach me how to insert the new tables?

 

I received this error message after installed

 

 

"1146 - Table 'toyshop_001.affiliate_sales' doesn't exist

 

select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from affiliate_sales

 

[TEP STOP]"

[nicko107]

Hi

 

See in the control panel of the hosting of your catalog is you have the phpMyAdmin or other database administrator, SQL, or similar

 

 

if you have phpMyAdmin then use it and select the database of your catalog

when you see the list with all tables see at top of page a menu, and click on SQL menu

then you have two options

option A: edit the affiliate.sql file to see the content, copy and paste it in the textarea box of that SQL page, and then click in Go button to insert the database tables of this contribution,

or option B: click on the Browser button and find the affiliate.sql file, then select it and click in Go button that are begin Browser button

 

 

only do this one time for dont duplicate the tables

 

 

***first do a backup of the database

 

 

regards

[vivaspark]

hi, nicko107,

 

Thanks for the reply, but I'm still getting the same error message:

 

"1146 - Table ''oyshop_001_affiliate.affiliate_affiliate' doesn't exist

 

select affiliate_email_address from affiliate_affiliate where affiliate_email_address = '[email protected]'

 

[TEP STOP]

 

 

I'm sorry to tell u that, I can't do any thing with my sql, pls see my screenshot:

 

 

http://media.pixpond.com/1xpwky.jpg

 

Please help!

I have been trying this for 2 weeks, but still can't find the solution.

Edited January 1, 2007 by vivaspark

[vivaspark]

Repost my screenshot:

 

 

http://i13.tinypic.com/2r6d5og.jpg