| smokyant2000 |
First Post Posted on: 06-08-12 08:41 AM |
| sql error |
|
| when in the MY ACCOUNT>MY MAIL the outbox gets an error saying : "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 'AND PrivMsgsBody.ID=' at line 1
Query:
SELECT * FROM PrivMsgs, PrivMsgsBody WHERE PrivMsgs.ID= AND PrivMsgsBody.ID=
Line 1171, File /home/anthony/public_html/cgi-bin/auction//PrivMail.pm.
Package: main, File: /home/anthony/public_html/cgi-bin/auction//PrivMail.pm, Line: 1171"
and when someone tries to read a mesege they got the error:"SQL 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 'AND PrivMsgsBody.ID=' at line 1
Query:
SELECT * FROM PrivMsgs, PrivMsgsBody WHERE PrivMsgs.ID= AND PrivMsgsBody.ID=
Line 1171, File /home/anthony/public_html/cgi-bin/auction//PrivMail.pm.
Package: main, File: /home/anthony/public_html/cgi-bin/auction//PrivMail.pm, Line: 1171"
please and thanks. |
|
|
|
|
|
 |
| mewsoft |
Reply #: 1 Posted on: 06-08-12 09:01 AM |
| Re: sql error |
|
The error message shows you are trying to view a message with an EMPTY ID "PrivMsgs.ID=", this means
you are trying to view none existing message, you may be deleted the message and trying to view
it by browser back button or cashed link.
|
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|
| smokyant2000 |
Reply #: 2 Posted on: 06-08-12 09:17 AM |
| Re: sql error |
|
just sent a private mesege and refreshed then checked the out box and the sent box and the new mesege doesnt show. and on the outbox it still shows: 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 'AND PrivMsgsBody.ID=' at line 1
Query:
SELECT * FROM PrivMsgs, PrivMsgsBody WHERE PrivMsgs.ID= AND PrivMsgsBody.ID=
Line 1171, File /home/anthony/public_html/cgi-bin/auction//PrivMail.pm.
Package: main, File: /home/anthony/public_html/cgi-bin/auction//PrivMail.pm, Line: 1171
and again thank you for your fast replies  |
|
|
|
|
|
| mewsoft |
Reply #: 3 Posted on: 06-08-12 09:39 AM |
| Re: sql error |
|
Sine these errors just now, what changes you have made to your system or updates you have done?
|
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| smokyant2000 |
Reply #: 4 Posted on: 06-08-12 09:49 AM |
| Re: sql error |
|
| i have had no reason to do anything on site after you updated. we turned the mouse over on homepage off and that is it. i just went to check on a mesege that was just sent and i get " 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 'AND PrivMsgsBody.ID=' at line 1
Query:
SELECT * FROM PrivMsgs, PrivMsgsBody WHERE PrivMsgs.ID= AND PrivMsgsBody.ID=
Line 1171, File /home/anthony/public_html/cgi-bin/auction//PrivMail.pm.
Package: main, File: /home/anthony/public_html/cgi-bin/auction//PrivMail.pm, Line: 1171"
i also do not do anything with the sql stuff cause i know nothing about it. |
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 06-08-12 09:58 AM |
| Re: sql error |
|
|
|
|
| smokyant2000 |
Reply #: 6 Posted on: 06-08-12 10:03 AM |
| Re: sql error |
|
| you are so kind! thank you. |
|
|
|
|
|
| mewsoft |
Reply #: 7 Posted on: 06-08-12 10:37 AM |
| Re: sql error |
|
The issue was with your forums, is installed and integrated but not updated with the auction since there was
changes to the sql tables which are shared, anyway , I fixed your site and will post the notes for others who
may face same issue.
Thanks |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| smokyant2000 |
Reply #: 8 Posted on: 06-08-12 11:10 AM |
| Re: sql error |
|
| you r the man! thank you so much. |
|
|
|
|
|
| smokyant2000 |
Reply #: 9 Posted on: 06-08-12 11:17 AM |
| Re: sql error |
|
now my links to the forum dont work  |
|
|
|
|
|
| mewsoft |
Reply #: 10 Posted on: 06-08-12 03:27 PM |
| Re: sql error |
|
As I already said, your forums are not upgraded to the latest integrated versions, you need to do fresh install
or upgrade the templates, language files, etc. If you do not have activity on it, just reinstall.
|
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| smokyant2000 |
Reply #: 11 Posted on: 06-09-12 04:06 AM |
| Re: sql error |
|
| well i tried the auto installer thing and i signed in but it didnt work or i missed a step. what on the price list do i need to purchase to update the searchawy and boardawy?
please and thanks. |
|
|
|
|
|
|
| mewsoft |
Reply #: 12 Posted on: 06-09-12 09:54 AM |
| Re: sql error |
|
If these products do not have activity, just do fresh install cheaper, just order installation service for each product:
| Auctionawy+Classifiedawy+Searchawy Installation Service $99 |
Order |
| Auctionawy+Classifiedawy Installation Service $75 |
Order |
| Auctionawy+Searchawy Installation Service $75 |
Order |
| Classifiedawy+Searchawy Installation Service $75 |
Order |
| Auctionawy Installation Service $49 |
Order |
| Classifiedawy Installation Service $49 |
Order |
| Searchawy Installation Service $49 |
Order |
| Boardawy Installation Service $49 |
Order |
| Payment Method Setup and Testing Service $125 |
Order |
| NetBuilder Installation Service $29 |
Order |
| NetPartners Installation Service $29 |
Order | |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| smokyant2000 |
Reply #: 13 Posted on: 06-09-12 12:25 PM |
| Re: sql error |
|
| thank you i will do that tonight. |
|
|
|
|
|
|