problem after upgrade to 1.8c, no advert posting possible

[monkeyra]

when posting an sdvert i get this error
Database error! Please report to System Administrator.

INSERT INTO pp_products (id,user,userid,cat,date,title,description,keywords,bigimage,bigimage2,bigimage3,approved,watermarked,ipaddress) values(NULL,'Monkeyra', 2, 9, 1089656243, 'test', 'fesfdsdfdfdsasd', '', '', '', '', 1, '', '213.122.60.229')

so at the moment, people can browse, but no-one can post adverts

[Chuck S]

where is the rest of the error message?

[monkeyra]

http://www.fordmondeo.org/classifieds/uploadproduct.php


if you try there m8, you'll see the error msg i posted is all i've got to help me post up.
I can post the same msg up, but all that seems to change is the ip address.

Database error! Please report to System Administrator.

INSERT INTO pp_products (id,user,userid,cat,date,title,description,keywords,bigimage,bigimage2,bigimage3,approved,watermarked,ipaddress) values(NULL,'Monkeyra', 2, 8, 1089742097, 'dffdf', 'fdffd', '', '', '', '', 1, '', '213.122.167.105')

[Chuck S]

Usually there is more to an error than that. I dont necessarily see anything wrong with that query. Have you tried running that query in phpmyadmin and seeing if it inserts.

[Chuck S]

You can PM me a link to phpmyadmin and by the way turn off on the fly watermarking as you do not have it set correctly

[monkeyra]

ok, on the fly watermarks was off. ???
you have PM of my details m8 for phpmyadmin

[monkeyra]

Any ideas on this yet?
Getting grief from my members

[Chuck S]

PM me your admin account. ALSO was this a new install or upgrade

[monkeyra]

PM on it's way.
This was an upgrade from 1.0 (or it could have been 1.1)

[Chuck S]

Your error is easy. You never ran your upgrade scripts your trying to run a 1.8 Classifieds on a 1.0 or 1.1 database

[monkeyra]

Bingo, Got it working now.
Thankyou Omegatron.