Results 1 to 9 of 9

Thread: error?

  1. #1
    valentino
    Guest

    Default 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' );'

  2. #2
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,634
    Blog Entries
    5

    Default

    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
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  3. #3
    valentino
    Guest

    Default database

    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

  4. #4
    Administrator Smoge's Avatar
    Join Date
    Mar 2005
    Posts
    6,634
    Blog Entries
    5

    Default

    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
    ModMySite Administrator

    Problems? Questions? Need modifications or other help with your site?

    Open A Ticket , Send Us An Email Or Give Us A Telephone Call +1 518-632-4152.

  5. #5
    valentino
    Guest

    Default Free mode

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

    regards

  6. #6
    Administrator ModMySite's Avatar
    Join Date
    Aug 2005
    Posts
    29

    Default

    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
    ------
    You can contact ModMySite by sending Smoge a private message, using our Contact Us form, or by sending an email to modmysite@modmysite.com

  7. #7
    valentino
    Guest

    Default Database

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

  8. #8
    Administrator ModMySite's Avatar
    Join Date
    Aug 2005
    Posts
    29

    Default

    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
    ------
    You can contact ModMySite by sending Smoge a private message, using our Contact Us form, or by sending an email to modmysite@modmysite.com

  9. #9
    valentino
    Guest

    Default Database

    thanks, that works...good explenation.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. HTTP 500 Internal Server Error (PHP Fatal error)
    By Nitrofish in forum Boonex Dolphin 7
    Replies: 3
    Last Post: 04-28-2010, 08:29 AM
  2. profile view error Fatal error: Class 'BxDolProfilePageView'
    By tawacom in forum General Troubleshooting
    Replies: 1
    Last Post: 08-27-2009, 07:10 PM
  3. Deleting users error and vb module refresh error
    By annd in forum General Troubleshooting
    Replies: 1
    Last Post: 06-24-2009, 02:04 AM
  4. Error: Transaction insertion error
    By paimai in forum Payment Processing
    Replies: 3
    Last Post: 11-08-2006, 07:52 AM
  5. Parse error : syntax error
    By Raoul in forum General Troubleshooting
    Replies: 8
    Last Post: 01-22-2006, 10:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •