Thread: error?

I keep getting this mail in my box, but the site is on free mode...what is this and how can i fix it?

Error in /dating/checkout/pre_checkout.php: Unknown column 'State' in 'field list'
Query: 'INSERT INTO `TransactionsMembership` (ID, Sum, State ) VALUES ( 1137279336204, 10.00, '0' );'

Now that the new server is configured, and the CVS is up - I have "awakened". LOL!

It would be great if you posted the table def for your TransactionsMembership table.

But, this might fix it too - if you want to do it blind (backup the table first):

Code:

ALTER TABLE `TransactionsMembership` ADD `State` int(3) default NULL;

Smoge

Ii don't know how to do that, but i guess it is not a major problem? How is it caused? By which action? What is a user doiing on the site that this error gets reported to me?

Please explain

Thanks

This is usually caused when the user tries to checkout with the aeDating paypal code.

You can run this sql command in phpmyadmin, in the SQL box for your database.

Rob

Site is in free mode remember, so there is no accesss to the checkout part.

regards

That alter statement does fix the problem. I had the exact same problem testing the checkout function a while ago. I think you just need to access that file to trip off the error message. I get weird messages like this in my error logs from search engine robots sometimes trying to access files that I don't even have on my system. Anyway, I can vouch for the fix.

regards, m

So i guess i have to play around in the php my admin?

Hello,

It's not that difficult. You bring up a phpmyadmin session, select your aedating database, if its working correctly you should see a set of table listings in the left column and another expanded set of the same table in the center screen. On the top of the center screen you see a tab menu. Select the "SQL" tab. You will see a box open up with some highlighted stuff in it. Copy that alter command and paste it into that window replacing whatever is in there. Click the GO button. You will see a pretty colored message that the table has been successfully altered etc. and VIOLA! you are done... to test it, you just need to try to access

http://yourdomain/checkout/pre_checkout.php

You should see a redirect to a paypal screen and not a database error. If you see the paypal screen (it will be complaining that it doesn't know what to do but that's okay), the problem has been fixed and you can just get out of it.

hope this helps,
m

thanks, that works...good explenation.