Welcome Guest!   Please Login or Register
Subscribe Today

You are not subscriber of DaDaNuke | Making PHP-Nuke Better!. You can subscribe from here now!

Sponsored Links




Search




Site Navigation

· Home
· About Us
· Advertise With Us
· Club
· CVS
· Downloads
· Feedback
· Forums
· Gallery
· Groups
· Journal
· Private Messages
· Search
· Stories Archive
· Submit News
· Top 10
· Topics
· Web Links
· Your Account

Survey

I Want This Addon:

SEO
Gaming
Commerce
Database
Security



Results
Polls

Votes 557

Advertisers




Top 10 Downloads

· 1: Hosting Module 1.7
· 2: PHP-Nuke 7.9.0.3.2.6
· 3: PHP-Nuke 8.0.0.3.3.1
· 4: PHP-Nuke Basic 8.0.0.3.3.2
· 5: GameHost 1.5
· 6: SimpleCart v.1.0
· 7: Driving Directions 1.2
· 8: Hosting Module v.1.8 FINAL
· 9: SimpleCart 0.91
· 10: Coldsteel

Who's Online

There are currently, 33 guest(s) and 1 member(s) that are online.

You are Anonymous user. You can register for free by clicking here

Total Hits

We received
3673213
page views since September 2005




DaDaNuke :: View topic - Arcade SQL-problems
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log inLog in 

Arcade SQL-problems

 
Post new topic   Reply to topic    DaDaNuke Forum Index -> BBtoNuke
View previous topic :: View next topic  
Author Message
Ivo2
dadaClub
dadaClub


Joined: Jan 13, 2007
Posts: 2
PostPosted: Sun Jan 14, 2007 11:14 am    Post subject: Arcade SQL-problems Reply with quote
First troubles
Code:
#1064 - 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 'DEFAULT CHARSET=latin1' at line 5

PHPNuke 7.9, bb2nuke 2.22, MySQL - 4.0.24_Debian-10sarge2
Any Ideas ?
Thx
Back to top
View user's profile Send private message
dadaBIT
General Manager
General Manager


Joined: Jun 23, 2005
Posts: 582
Location: United States
PostPosted: Tue Jan 16, 2007 5:14 am    Post subject: Reply with quote
Greetings Ivo2, welcome to the boards and most certainly thanks for the continued support! That particular concern is quite popular I am afraid. You may find the answers you seek young Padawan here.

Regards,
Kevin
_________________

Visit the DaDaNuke Wish List
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Ivo2
dadaClub
dadaClub


Joined: Jan 13, 2007
Posts: 2
PostPosted: Thu Jan 18, 2007 1:21 pm    Post subject: Reply with quote
Thx Kevin
Back to top
View user's profile Send private message
manik
dadaSupport
dadaSupport


Joined: Oct 26, 2005
Posts: 131
Location: Maryland
PostPosted: Thu Jul 05, 2007 5:39 am    Post subject: Reply with quote
Hopefully it told you to remove that line of code.

I usually do a find and remove feature and remove this line of code from every call in the sql.

Code:
'DEFAULT CHARSET=latin1'


And remember if you ever export an sql just look up in the right hand corner of your export page and check the disable foreign keys as the issue above is a foreign key.Smile
_________________
When you try and fail it hurts but when you try and quit you die.
Back to top
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    DaDaNuke Forum Index -> BBtoNuke All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
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 phpBB Group Version 2.0.6 of PHP-Nuke Port by Tom Nitzschner © 2002 www.toms-home.com
Theme designed by Western Studios



Terms of Use | Privacy Policy © 1996-2007, DaDaNuke

Listed on FeedBurner

PHP-Nuke Copyright © 2006 by Francisco Burzi. This is free software, and you may redistribute it under the GPL.
PHP-Nuke comes with absolutely no warranty, for details, see the license.

Theme Designed by Western Studios