|
Haven't registered yet? Do it here now!
|
travs
Joined: 15 Mar 2006 Posts: 12
|
|
|
|
|
|
|
Posted: Wed Mar 15, 2006 6:28 am Post subject: MySQL Problem |
|
|
|
|
|
|
|
|
|
|
I have chmod'd soinfo.inc.php, sohtml, sotemp and thumbs. i also typed in the proper db name, host name, username and password. I also uploaded files in binary mode.
when I clicked on the install button on the so-install.php, this gives me the message:
Query to MySQL Failed: 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 'out bigint(20) NOT NULL default '0', galsalltime bigint(20) NOT NULL default '' at line 5
what's wrong? |
|
|
|
|
|
|
|
kaktus Owner
Joined: 22 May 2004 Posts: 1576 Location: CheapestAdultScripts.com
|
|
|
|
|
|
|
Posted: Wed Mar 15, 2006 2:04 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
hm, it is an error with a mysql query the install file does to create the necessary tables in the mysql..
probably the mysql server is kinda old. Can you please ask your host what version is your mysql server? _________________
|
|
|
|
|
|
|
|
travs
Joined: 15 Mar 2006 Posts: 12
|
|
|
|
|
|
|
Posted: Thu Mar 16, 2006 12:41 am Post subject: |
|
|
|
|
|
|
|
|
|
|
i'm downloading zend optimizer now. maybe that'll fix the problem. i'll let you know what happens next. thanks |
|
|
|
|
|
|
|
kaktus Owner
Joined: 22 May 2004 Posts: 1576 Location: CheapestAdultScripts.com
|
|
|
|
|
|
|
Posted: Thu Mar 16, 2006 8:42 am Post subject: |
|
|
|
|
|
|
|
|
|
|
i don't think zend optimizer will fix the problem, since this is a problem with the mysql.. _________________
|
|
|
|
|
|
|
|
travs
Joined: 15 Mar 2006 Posts: 12
|
|
|
|
|
|
|
Posted: Thu Mar 16, 2006 3:57 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
you say it's in the mysql while my hosting provider said they have the latest mysql and the problem is not on theirs. i am confused... |
|
|
|
|
|
|
|
kaktus Owner
Joined: 22 May 2004 Posts: 1576 Location: CheapestAdultScripts.com
|
|
|
|
|
|
|
Posted: Thu Mar 16, 2006 5:10 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
well, yes, i am 100% sure its something with the mysql.
also i am almost sure it is from your host, since this install file works for every other user of the script out there and noone complained from such a problem like yours..
Anyways, we must try to find your issue. Can you please provide me ftp and mysql access (phpmyadmin) to your server, so i can go and investigate and find a solution.. Just PM them here or hit me up on icq..
Thanks! _________________
|
|
|
|
|
|
|
|
travs
Joined: 15 Mar 2006 Posts: 12
|
|
|
|
|
|
|
Posted: Thu Mar 16, 2006 6:10 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
|
|
Posted: Fri Apr 07, 2006 2:45 am Post subject: |
|
|
|
|
|
|
|
|
|
|
I also get that message when I try to install. You found out what the deal is yet?!? |
|
|
|
|
|
|
|
kaktus Owner
Joined: 22 May 2004 Posts: 1576 Location: CheapestAdultScripts.com
|
|
|
|
|
|
|
Posted: Sun Apr 09, 2006 9:04 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
yeah, we resolved the problem.
I will give you a fix tomorrow, just got back home from my weekend trip to my hometown... _________________
|
|
|
|
|
|
|
|
guru
Joined: 17 May 2006 Posts: 3
|
|
|
|
|
|
|
Posted: Wed May 17, 2006 4:02 pm Post subject: SQL Problem |
|
|
|
|
|
|
|
|
|
|
I am having the same MySQL problem as travs and who99. Any luck on the fix. Thanks |
|
|
|
|
|
|
|
kaktus Owner
Joined: 22 May 2004 Posts: 1576 Location: CheapestAdultScripts.com
|
|
|
|
|
|
|
Posted: Wed May 17, 2006 4:58 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
huh, i remember this case. I found out the problem and fixed it, but seems lik i forgot to release the fix. Give me couple of mins and will release it now along with the rest things i fixed in so, coz there were some small problems with some of the new features in v 2.0 _________________
|
|
|
|
|
|
|
|
kaktus Owner
Joined: 22 May 2004 Posts: 1576 Location: CheapestAdultScripts.com
|
|
|
|
|
|
|
Posted: Wed May 17, 2006 5:47 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
v 2.1 just released.
guru just grab the full install package again and reupload everything to your server, and continue with install.
Let me know if you need more help. _________________
|
|
|
|
|
|
|
|
guru
Joined: 17 May 2006 Posts: 3
|
|
|
|
|
|
|
Posted: Thu May 18, 2006 4:40 am Post subject: Works Great |
|
|
|
|
|
|
|
|
|
|
Thanks Kaktusan, it works great. |
|
|
|
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
|
phpBB Template designed by SkaidonDesigns |
|
| |