Welcome Visitor, Please Login or Register Now Thursday, March 28, 2024 07:40 PM 
Forums Index > Mewsoft Products > Auctionawy > Help! I broke the software!
New Topic   New Reply
Search for:
Author Message
conuremom conuremom's personal page
Registered Member
Posts: 76 Display member's posts
Joined: 12-07-05 03:13 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Help! I broke the software! Edit Delete Reply with quote Quote
First Post Posted on: 08-02-09 06:02 PM next post first post
I was altering background colors today, and somehow I must have damaged a SQL file. But now when I click on the "upload file" button on the sell.htm page, I get this error message;\ \ 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: \ SELECT Parent FROM Auction_Categories WHERE Cat_ID=\ Line 1231, File /home/vegaauct/public_html/cgi-bin/auction/SQLlib.pm.\ \ HELP! HOW DO I FIX THIS?
wannauseit wannauseit's personal page
Registered Member
Posts: Display member's posts
Joined: 03-28-24 07:40 PM
Member Offline
View Member's Profile PM
 
Back to top
Re: Help! I broke the software! Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 08-03-09 07:27 AM next post previous post
I don't think you damaged a SQL database by editing templates.\ \ From the error, it looks like either you removed something from the Sell.html file, or might have edited the SQLib.pm file.\ \ If you were only editing the Sell.html file, I would suggest replacing it from your backup.\ \ I hope that fixes it!
conuremom conuremom's personal page
Registered Member
Posts: 76 Display member's posts
Joined: 12-07-05 03:13 PM
Member Offline
View Member's Profile Send private message
 
Back to top
broke the software... Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 08-03-09 11:47 AM next post previous post
"From the error, it looks like either you removed something from the Sell.html file, or might have edited the SQLib.pm file.\ If you were only editing the Sell.html file, I would suggest replacing it from your backup"\ \ Thanks. I did nothing with SQLlib.pm. I edited the Sell.htm file only. But I've never done a backup, don't even know how...\ Do you know how can I get the original sell.htm file again?
wannauseit wannauseit's personal page
Registered Member
Posts: Display member's posts
Joined: 03-28-24 07:40 PM
Member Offline
View Member's Profile PM
 
Back to top
Re: Help! I broke the software! Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 08-03-09 12:13 PM next post previous post
Yes, you can login to your account at Mewsoft and download the Zip file and extract it on your computer. Then, FTP the file Sell.html to the /data/templates directory.\ \ If you don't have FTP, then you can open the file and copy and paste the contents into the Sell template in your Template editor in Admin.
conuremom conuremom's personal page
Registered Member
Posts: 76 Display member's posts
Joined: 12-07-05 03:13 PM
Member Offline
View Member's Profile Send private message
 
Back to top
broke the software--FIXED Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 08-03-09 01:07 PM next post previous post
I fixed it. I looked at the sell.htm code on the admin demo at the Mewsoft site, copied & pasted into my own sell.htm.\ That took care of the problem immediately. (I'm obviously not a "real" programmer) \ Thanks!
wannauseit wannauseit's personal page
Registered Member
Posts: Display member's posts
Joined: 03-28-24 07:40 PM
Member Offline
View Member's Profile PM
 
Back to top
Re: Help! I broke the software! Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 08-03-09 02:02 PM last post previous post
I'm glad you got it fixed!\ \ I usually keep a backup copy of the script, and a "working" copy.\ \ If I mess something up, I can either compare code or replace the file from backup.\ \ I didn't think about using the demo, I'm glad you thought of it!
Page 1 of 1
Go to page:

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