i managed to uninstall the query or however u did it by doing this:
PHP Code:
DELETE FROM store WHERE id>=1
then i ran the queries again in query no.5 and it they worked...
so i thought all was fine...
but its still the same... when i goto change my custom title or any other action in the store ... (im just using change custom title as an example)... it gives me this error...
____________________________________________
PHP Code:
Database error in vBulletin 2.2.3:
Invalid SQL: UPDATE store SET quantity=quantity-1 WHERE id=2
mysql error: Unknown column 'quantity' in 'field list'
mysql error number: 1054
Date: Tuesday 04th of June 2002 05:07:45 PM
Script: [url]http://www.emceebattleraps.com/forums/forums/store.php[/url]
Referer:
_________________________________________
the funny thing is that the link to my forums is actually...
www.emceebattleraps.com/forums ....
i dont kno why its got forums/forums/store.php in that error...
The next things is that in View/Modfiy actions... i goto edit an action ... for example when i goto edit change custom title i click "Submit" after making the necessary changes i want and it gives me this error:
________________________________________-
PHP Code:
Database error in vBulletin Control Panel 2.2.3:
Invalid SQL: UPDATE store set title='Change Custom Title', costs='300', sold='3', imgurl='title.gif', description='With this action you can get a custom title and if you dont have one already then get one', ok='Y', quantity='' WHERE id=2
mysql error: Unknown column 'quantity' in 'field list'
mysql error number: 1054
Date: Tuesday 04th of June 2002 05:13:44 PM
Script: [url]http://www.emceebattleraps.com/forums/forums/admin/storeadmin.php[/url]
Referer:
___________________
yet again its got that extra /forums in ... and i dont kno why...
can any1 help???
Thanks in Advance