Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 08-13-2002 22:56:00
Script Error
Hmmm, my ccp5 has been working great for a few days now. Havn't touched it since last Saturday. Now all of a sudden when I try to go to the splash, or to the admin section I get the exact same following error. No Idea what is going on. I do use mysql for the database and some other tables.
Script Execution Error
The following error was just encountered:
DBD::mysql::db do failed: You have an error in your SQL syntax near '' at line 6 at /home/stnecorp/public_html/ccp5/cgi-bin/library/common/database.pl line 526.
Will
wwwstnecorp.com
(New cart to be online as soon as I've got it looking right)
Will
Offline
#2 08-14-2002 02:34:20
- Guest
- Guest
Re: Script Error
Webmaster,
Here's what I did to fix this error (at least it got his cart working again)
1. Copied tables.csv to tables.csv.bak
2. Edited tables.csv and changed a few of the tables from "ALT" back to "CSV"
3. Opened his cart in a browser, everything loaded fine. Though no product data was there as he had it all stored in a MySQL database. Just wanted to check that the basic cgi was working.
4. Restored tables.csv from the backup
Now everything is working again as it was before the error.
Tables.csv became corrupt? Cookie error? This is a strange error huh, why would doing this simple process restore function.
Myros
#3 08-14-2002 06:38:59
Re: Script Error
We saw the same error on our demo Sunday night and have been trying to track it down. The issue isn't with tables.csv - that just tells the program where to look for the db. I think it may have to do with the daily stats routine not getting the date correct for insert into the db. We're checking it out.
Nick Hendler
Offline
#4 08-14-2002 07:43:50
Re: Script Error
I can't believe I did that. The corect URL is http://www.neuralgrid.com
>I would like to thank Myros
>for his help. Myros
>works for my ISP and
>he has another client of
>the ISP that he does
>more webmaster duties for.
>This other client also runs
>CCP. Because of Myros
>is why my cart works.
> So here comes a
>plug for the ISP.
>
>http://www.neuralgrid.com
>
>Very affordable hosting, works GREAT with
>CCP5! I am in no
>way affilated with them, but
>they are my ISP, and
>I am so happy I
>chose to go with them.
> I feel I get
>more than my money's worth
>with them. The very
>basic plan they offer for
>$4.99 a month and has
>all features needed to run
>CCP5 including MySQL. So
>if you are looking for
>a new host, please visit
>my friends at NeuralGrid.
>
>Ok, thats my plug. 
>
>
>Will
>www.stnecorp.com
>(New cart to be online as
>soon as I get the
>shipping update)
Will
wwwstnecorp.com
(New cart to be online as soon as I've got it looking right)
Will
Offline
#5 08-14-2002 08:57:26
- Guest
- Guest
Re: Script Error
LOL, thanks for the plug Will.
Thanks for the update webmaster. I'll keep an eye here for any further info on this issue.
Cheers,
Myros
#6 08-14-2002 22:40:51
- Guest
- Guest
Re: Script Error
Hey Will,
Thanks for the heads up on this hosting company. I looked at their options and prices and made the switch today. I was going to switch to a Linux server anyway and after the problems I've been having with my other server, then seeing these people and the good words you had to say about them I made the switch. I went with the #3 package at $29.95/month. Lots of space, transfer, mysql, emails, modules, ect.
Thanks again