Welcome Visitor, Please Login or Register Now Friday, March 29, 2024 12:49 AM 
Forums Index > Mewsoft Products > Auctionawy > Error No CAT_ID!
New Topic   New Reply
Search for:
Author Message
abner abner's personal page
Registered Member
Posts: 57 Display member's posts
Joined: 03-29-24 12:49 AM
Member Offline
View Member's Profile Send private message MSN Messenger: clickcheaper
 
Back to top
Error No CAT_ID! Edit Delete Reply with quote Quote
First Post Posted on: 11-27-08 10:02 PM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 12:49 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 11-27-08 10:25 PM next post previous post

Your site does not show any categories.

http://good247.com/cgi-bin/auction/auction.cgi

Again do not load any database backup from old versions.


Mewsoft Support
www.mewsoft.com

abner abner's personal page
Registered Member
Posts: 57 Display member's posts
Joined: 03-29-24 12:49 AM
Member Offline
View Member's Profile Send private message MSN Messenger: clickcheaper
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 11-29-08 04:56 AM next post previous post
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 romahawk's personal page
Registered Member
Posts: 122 Display member's posts
Joined: 02-18-05 08:02 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 11-29-08 06:16 AM next post previous post
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 abner's personal page
Registered Member
Posts: 57 Display member's posts
Joined: 03-29-24 12:49 AM
Member Offline
View Member's Profile Send private message MSN Messenger: clickcheaper
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 11-29-08 03:39 PM next post previous post
Ahamed, can you look t this issue please!
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 12:49 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 11-29-08 07:48 PM next post previous post
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 abner's personal page
Registered Member
Posts: 57 Display member's posts
Joined: 03-29-24 12:49 AM
Member Offline
View Member's Profile Send private message MSN Messenger: clickcheaper
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 11-30-08 03:42 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 12:49 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 7 Posted on: 11-30-08 06:08 AM next post previous post

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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 12:49 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Error No CAT_ID! Edit Delete Reply with quote Quote
Reply #: 8 Posted on: 11-30-08 07:00 AM last post previous post
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

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print