| conuremom |
First Post Posted on: 08-02-09 06:02 PM |
| Help! I broke the software! |
|
| 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 |
Reply #: 1 Posted on: 08-03-09 07:27 AM |
| Re: Help! I broke the software! |
|
| 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 |
Reply #: 2 Posted on: 08-03-09 11:47 AM |
| broke the software... |
|
| "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 |
Reply #: 3 Posted on: 08-03-09 12:13 PM |
| Re: Help! I broke the software! |
|
| 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 |
Reply #: 4 Posted on: 08-03-09 01:07 PM |
| broke the software--FIXED |
|
| 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 |
Reply #: 5 Posted on: 08-03-09 02:02 PM |
| Re: Help! I broke the software! |
|
| 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! |
|
|
|
|
|
|
