Welcome Visitor, Please Login or Register Now Monday, December 16, 2019 03:21 AM 
New Topic   New Reply
Search for:
Author Message
smokyant2000 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
sql error Edit Delete Reply with quote Quote
First Post Posted on: 11-30-11 08:50 AM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-16-19 03:21 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: sql error Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 11-30-11 09:11 AM next post previous post

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 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 11-30-11 09:26 AM next post previous post
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 smile
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-16-19 03:21 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: sql error Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 11-30-11 09:49 AM next post previous post

Sine these errors just now, what changes you have made to your system or updates you have done?

 


Mewsoft Support
www.mewsoft.com

smokyant2000 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 11-30-11 09:59 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-16-19 03:21 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: sql error Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 11-30-11 10:08 AM next post previous post
OK, let me check ...

Mewsoft Support
www.mewsoft.com

smokyant2000 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 11-30-11 10:12 AM next post previous post
you are so kind! thank you.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-16-19 03:21 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: sql error Edit Delete Reply with quote Quote
Reply #: 7 Posted on: 11-30-11 10:47 AM next post previous post

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 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 8 Posted on: 11-30-11 11:19 AM next post previous post
you r the man! thank you so much.
smokyant2000 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 9 Posted on: 11-30-11 11:27 AM next post previous post
now my links to the forum dont work frown
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-16-19 03:21 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: sql error Edit Delete Reply with quote Quote
Reply #: 10 Posted on: 11-30-11 03:37 PM next post previous post

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 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 11 Posted on: 12-01-11 04:16 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 12-16-19 03:21 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: sql error Edit Delete Reply with quote Quote
Reply #: 12 Posted on: 12-01-11 10:04 AM next post previous post

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 smokyant2000's personal page
Registered Member
Posts: 145 Display member's posts
Joined: 05-30-08 06:14 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: sql error Edit Delete Reply with quote Quote
Reply #: 13 Posted on: 12-01-11 12:35 PM last post previous post
thank you i will do that tonight.
Page 1 of 1
Go to page:

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