Forums Index > Mewsoft Products > Searchawy > My directory can't process new submission
cosmo3 First Post Posted on: 06-30-12 02:22 AM
My directory can't process new submission
When trying to process new submission, I got the following error:\ "SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1\ Query: \ INSERT INTO Keywords VALUES (1162777261, 757, 'nutrition', 0, )\ Line 169, File /home/cosmdes5/public_html/searchjungle/cgi-bin/dir/URLmgr.pm."\ \ I did not change any setting. It just happened suddenly (directory is at www.searchjungle.com).\ \ Please help.\ \ Thank you
mewsoft Reply #: 1 Posted on: 06-30-12 05:43 AM
Re: My directory can't process new submission
Nothing changes by itself, anyway I see you have 46524 listing already which means your installation was working, delete this listing which produced this error and try other listings.

Mewsoft Support
www.mewsoft.com
cosmo3 Reply #: 2 Posted on: 06-30-12 11:51 AM
new submissions and change in old submissions produce error
I have tried deleting the new submissions that produced the error and submit new ones. So far no Luck! It only worked once out of 10 times and has not worked for the last 8 times I tried with both new or old categories. Even a change in previously accepted listings does not work!\ I guess I am stucked at this point.\ Thank you
cosmo3 Reply #: 3 Posted on: 06-30-12 12:54 PM
new submissions and change in old submissions produce error
I have tried deleting the new submissions that produced the error and submit new ones. So far no Luck! It only worked once out of 10 times and has not worked for the last 8 times I tried with both new or old categories. Even a change in previously accepted listings does not work!\ I guess I am stucked at this point.\ Thank you
cosmo3 Reply #: 4 Posted on: 07-01-12 01:18 AM
Re: My directory can't process new submission
The directory is working fine now. Fro those who ever have this problem, leave the default ranking system alone! I change ranking score for the default title and description keyword, which resulted in an error when I tried accepting new submission.\ Thanks anyway for your help.