| abner |
First Post Posted on: 11-27-08 10:02 PM |
| Error No CAT_ID! |
|
| My last post was deleted, why? can you help me with this?\
\
SQL Error: You have an error in your SQL syntax near ')' at line 1\
Query:\
SELECT Name FROM Auction_Categories_Name WHERE (Lang='English' AND Cat_ID=)\
Line 1280, File /home/httpd/vhosts/mysite.com/cgi-bin/auction/SQLlib.pm.\
I did full installation again and still same error, bu only on subcategories.\
\
Regards,\
abner |
|
|
|
|
|
| mewsoft |
Reply #: 1 Posted on: 11-27-08 10:25 PM |
| Re: Error No CAT_ID! |
|
|
|
|
| abner |
Reply #: 2 Posted on: 11-29-08 04:56 AM |
| Re: Error No CAT_ID! |
|
| Could you please crate a member on my site an try to submit an auction, i have installed all over again from new version.\
\
thanks \
Abner |
|
|
|
|
|
| romahawk |
Reply #: 3 Posted on: 11-29-08 06:16 AM |
| Re: Error No CAT_ID! |
|
| Just logged into your site and tried to create a test auction but you are not giving new users a credit to start and you want payment in advance so I could not post an auction. Also your upload directory would not accep JPEG files so I had to upload a Gif which loaded fine. Everything worked the way it should until I tried to submit the auction and had no money in my account so my item was rejected. |
|
|
|
|
|
| abner |
Reply #: 4 Posted on: 11-29-08 03:39 PM |
| Re: Error No CAT_ID! |
|
| Ahamed, can you look t this issue please! |
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 11-29-08 07:48 PM |
| Re: Error No CAT_ID! |
|
| This still same your first error when you loaded old databases, whay you need to do is to delete the dataabse itself, recreate the sql tables, make sure you transferred all the cgi files in ascii mode. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| abner |
Reply #: 6 Posted on: 11-30-08 03:42 AM |
| Re: Error No CAT_ID! |
|
| Hi, i now i used the auto installation too, and i still got the same error SQL Error: You have an error in your SQL syntax near ')' at line 1\
Query: \
SELECT Name FROM Auction_Categories_Name WHERE (Lang='English' AND Cat_ID=)\
Line 1280, File /home/httpd/vhosts/mysite.com/cgi-bin/v8/SQLlib.pm.\
\
diferent directory, new database, transfered all cgi files in ascii mode.\
\
What can i do now???\
\
Sincerly,\
Abner |
|
|
|
|
|
| mewsoft |
Reply #: 7 Posted on: 11-30-08 06:08 AM |
| Re: Error No CAT_ID! |
|
Email me your site FTP info, your mysq database info and I'll check it and also your admin.cgi url and login. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| mewsoft |
Reply #: 8 Posted on: 11-30-08 07:00 AM |
| Re: Error No CAT_ID! |
|
I upload all the cgi files, set all permissions to 755 (it was 777) and deleted the sql tables, recreated the sql tables, loaded the default database and submitted 2 items and every thing seems normal. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|
