tfft |
First Post Posted on: 02-09-12 11:14 AM |
I keep getting these emails concerning cron daemons |
|
these emails read as:\
\
[Sat Aug 2 23:00:04 2008] AutoProcess.cgi: DBD::mysql::db do failed: Unknown column 'AutoExtend' in 'field list' at /home/aljohn12/public_html/auctions/cgi-bin/SQLlib.pm line 82.\
Content-type: text/html\
\
\
\
Mewsoft - www.mewsoft.com \
\
\
\
\
\
\
\
\
\
\
\
\
\
\
\
SQL Error\
\
\
| \
\
\
\
\
\
\
\
\
\
\
\
\
SQL Error: Unknown column 'AutoExtend' in 'field list' Query: INSERT INTO Items (ID, Cat_ID, CatA_ID, User_ID, Bids, Current_Bid, Sponser, Price, Title, Description, Image, Quantity, Sold, Start_Bid, Increment, Reserve, Buy_Price, Duration, Start_Time, End_Time, Resubmit, Resubmited, AutoExtend, Private, PaymentMethods, PaymentDetails, ShipTo, ShipToDetails, ShipTime, ShipPayment, ShipPaymentDetails, Bold, Colored, Featured, Featured1, Gift_Icon, Media, Media_Show, Item_Language, Gallery, Gallery_Img, Banner, Homepage, Status, Reason, Currency, SubTitle, Type, ShipAddress, ShipZip, ShipInsurance, Insurance, ReturnPeriod, ReturnMethod, ReturnDetails, ShipService1, ShipCost1, ShipCostNext1, ShipService2, ShipCost2, ShipCostNext2, ShipService3, ShipCost3, ShipCostNext3, ShipDetails, PackageWeight, PackageWeight1, PackageType, PackageW, PackageH, PackageL, PackageUnit, SalesTax, ShipTax, Ad1, Ad2, Ad3, Ad4, Ad5, Ad6, Ad7, Ad8, Ad9, Ad10, Ad11, Ad12, Ad13, Ad14, Ad15, Ad16, Ad17, Ad18, Ad19, Ad20, Ads1, Ads2, Ads3, Ads4, Ads5, Ads6, Ads7, Ads8, Ads9, Ads10, Ads11, Ads12, Ads13, Ads14, Ads15, Ads16, Ads17, Ads18, Ads19, Ads20) VALUES ('1217736004', '12', '121', 'aljohn123', '0', '0.00000', '0', '0.00000', 'Testing computer sell', 'this is a test description box', '', '2147483647', '0', '0.00000', '0', '0.00000', '10.00000', '30', '1217721604', '1220313604', '50', '7', '0', '0', '1', '', '3', '', '1', '1', '', '1', 'red', '1', '1', 'easter.gif', 'awgep7rtjmx008k.gif', '2', 'English', '1', '', '', 'http://www.freedom-factor.com', '1', '0', 'USD', 'Testing sub title', '1', 'Saginaw, MI', '48601', '2', '2.00000', '6', '2', '', '', '0.00000', '0.00000', '', '0.00000', '0.00000', '', '0.00000', '0.00000', '', '0.00000', '0.00000', '', '0.00000', '0.00000', '0.00000', '', '0.06000', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '') Line 82, File /home/aljohn12/public_html/auctions/cgi-bin/SQLlib.pm. \
\
| \
\
\
\
| \
\
\
\
\
| \
\
\
\
| \
\
\
\
\
\
\
\
there is an error message starting at the top that may have something to do with it. |
The Freedom Factor Team (TFFT)\
www.freedom-factor.com |
|
|
|
|
|
mewsoft |
Reply #: 1 Posted on: 02-10-12 08:07 AM |
Re: I keep getting these emails concerning cron daemons |
|
This is because you upgraded the cgi files without completng the upgrades steps which was including addition of sql column, when you apply an upgrade the need to apply all upgrade steps, search teh announcements forums for the upgrade that includes a sql statment autoextend and apply this sql command. I see also your version is 2 years old!. Thanks |
Mewsoft Support www.mewsoft.com
|
|
|
|
|
|