Quick Login   
 
Register AdminFusion Tutorials
 
Featured Sponsors


One.com Domain and Hosting


Register
Forum of the Month
Australian Webmaster
fotm

A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.

Tag Cloud
Latest Threads
Forum Stats
8,063 Members
165,816 Posts
45 Users Online

Please welcome our newest member, conorod!

Affiliates
Go Back AdminFusion » The Break Room » Off Topic » Need help with sql file help!
Welcome to the AdminFusion. AdminFusion is the ultimate resource for forum administrators and moderators. With exclusive articles, interviews with the experts, free downloadable skins, and the revolutionary post exchange system - PostFusion, AdminFusion is the place to go for all of your forum needs.  By joining AdminFusion, you will become part of a thriving admin community and immediately gain access to all of these resources. Registration is fast, simple and absolutely free so please join us today!
Want more than our forums? Try these: Post Fusion Forum Matrix
Old 11-07-2006, 04:56 PM   #1

Thomas's Avatar

Title: Forum Addict

Points: 8,414, Level: 27Points: 8,414, Level: 27Points: 8,414, Level: 27
Level up: 28%, 336 Points neededLevel up: 28%, 336 Points neededLevel up: 28%, 336 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jun 2006

Posts: 1,320

Location: East Coast, USA

Thomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to behold
Send a message via AIM to Thomas Send a message via MSN to Thomas Send a message via Yahoo to Thomas Send a message via Skype™ to Thomas  
 
Need help with sql file help!

I downloaded the imagehosting script from getyourscripts and I followed all the instructions correctly, but when I try to put that image.sql file into phpmyadmin I come up with this

Error

SQL query:
/*!40101 SET CHARACTER SET '' */;


MySQL said:
#1115 - Unknown character set: ''

Anyone know whats happening?
Reply With Quote
Old 11-07-2006, 05:50 PM   #2

LarryB's Avatar

Title: AF Lead Developer

Points: 6,450, Level: 23Points: 6,450, Level: 23Points: 6,450, Level: 23
Level up: 24%, 100 Points neededLevel up: 24%, 100 Points neededLevel up: 24%, 100 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2005

Posts: 1,186

Location: OHIO, US

LarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud of
Send a message via MSN to LarryB  
 
What version of mysql is your host/server running on?
__________________
Do not post your PF private key in public.

Did I help you with this post? If so, pls click the rep button or send money.
Reply With Quote
Old 11-07-2006, 07:35 PM   #3

Thomas's Avatar

Title: Forum Addict

Points: 8,414, Level: 27Points: 8,414, Level: 27Points: 8,414, Level: 27
Level up: 28%, 336 Points neededLevel up: 28%, 336 Points neededLevel up: 28%, 336 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jun 2006

Posts: 1,320

Location: East Coast, USA

Thomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to behold
Send a message via AIM to Thomas Send a message via MSN to Thomas Send a message via Yahoo to Thomas Send a message via Skype™ to Thomas  
 
MySQL version 4.1.21-standard
Reply With Quote
Old 11-07-2006, 08:04 PM   #4

LarryB's Avatar

Title: AF Lead Developer

Points: 6,450, Level: 23Points: 6,450, Level: 23Points: 6,450, Level: 23
Level up: 24%, 100 Points neededLevel up: 24%, 100 Points neededLevel up: 24%, 100 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2005

Posts: 1,186

Location: OHIO, US

LarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud of
Send a message via MSN to LarryB  
 
Can you give me an example of some of the sql? If you would prefer not to post it up here you can pm me. My guess is that there is a charset variables on the create table statements that point to a character set that is not available on the server.
__________________
Do not post your PF private key in public.

Did I help you with this post? If so, pls click the rep button or send money.
Reply With Quote
Old 11-07-2006, 09:10 PM   #5

Thomas's Avatar

Title: Forum Addict

Points: 8,414, Level: 27Points: 8,414, Level: 27Points: 8,414, Level: 27
Level up: 28%, 336 Points neededLevel up: 28%, 336 Points neededLevel up: 28%, 336 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jun 2006

Posts: 1,320

Location: East Coast, USA

Thomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to beholdThomas is a splendid one to behold
Send a message via AIM to Thomas Send a message via MSN to Thomas Send a message via Yahoo to Thomas Send a message via Skype™ to Thomas  
 
Reply With Quote
Old 11-07-2006, 09:48 PM   #6

n1ck's Avatar

Title: Apprentice

Points: 3,781, Level: 17Points: 3,781, Level: 17Points: 3,781, Level: 17
Level up: 18%, 69 Points neededLevel up: 18%, 69 Points neededLevel up: 18%, 69 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jul 2006

Posts: 420

Location: Cleveland, Ohio

n1ck has a spectacular aura aboutn1ck has a spectacular aura about
Send a message via AIM to n1ck Send a message via MSN to n1ck  
 
Why did your cpanel login come up on my screen when I clicked this thread?
Reply With Quote
Old 11-07-2006, 09:49 PM   #7

LarryB's Avatar

Title: AF Lead Developer

Points: 6,450, Level: 23Points: 6,450, Level: 23Points: 6,450, Level: 23
Level up: 24%, 100 Points neededLevel up: 24%, 100 Points neededLevel up: 24%, 100 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2005

Posts: 1,186

Location: OHIO, US

LarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud of
Send a message via MSN to LarryB  
 
Quote:
Originally Posted by n1ck View Post
Why did your cpanel login come up on my screen when I clicked this thread?
Had to do with the image in his post. I removed it.
__________________
Do not post your PF private key in public.

Did I help you with this post? If so, pls click the rep button or send money.
Reply With Quote
Old 11-07-2006, 09:51 PM   #8

LarryB's Avatar

Title: AF Lead Developer

Points: 6,450, Level: 23Points: 6,450, Level: 23Points: 6,450, Level: 23
Level up: 24%, 100 Points neededLevel up: 24%, 100 Points neededLevel up: 24%, 100 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2005

Posts: 1,186

Location: OHIO, US

LarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud of
Send a message via MSN to LarryB  
 
Thoma,

Try this. Every where that you see /* put a # in front of it. I don't believe that /* is a valid comment sequence for that version of myself. So it would be like this.

#/*

That way mysql will ignore those lines like it is supposed to.
__________________
Do not post your PF private key in public.

Did I help you with this post? If so, pls click the rep button or send money.
Reply With Quote
Old 11-07-2006, 09:59 PM   #9

Jolteon's Avatar

Title: Forum Junkie

Points: 18,280, Level: 41Points: 18,280, Level: 41Points: 18,280, Level: 41
Level up: 42%, 670 Points neededLevel up: 42%, 670 Points neededLevel up: 42%, 670 Points needed
Activity: 13%Activity: 13%Activity: 13%

Join Date: Feb 2006

Posts: 3,629

Location: Holmfirth, England

Jolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant futureJolteon has a brilliant future
Send a message via MSN to Jolteon  
 
Quote:
Originally Posted by n1ck View Post
Why did your cpanel login come up on my screen when I clicked this thread?
I got that too.
__________________
http://EasyToHide.Info
Visit my proxy for anonymous surfing!

Reply With Quote
Old 11-07-2006, 10:03 PM   #10

csquare016's Avatar

Title: Apprentice

Points: 2,781, Level: 15Points: 2,781, Level: 15Points: 2,781, Level: 15
Level up: 16%, 269 Points neededLevel up: 16%, 269 Points neededLevel up: 16%, 269 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Aug 2006

Posts: 295

csquare016 is on a distinguished road
Send a message via AIM to csquare016 Send a message via MSN to csquare016  
 
Hi thoma, this must be something due to the version of your mySQL, I really am no pro with support with mySQL related issues but that is my guess. Reason being, when I installed a demo on my host(Hosted by mself) it worked fine.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

 
Posting Rules

Similar Threads
Thread Thread Starter Forum Replies Last Post
[HOW-TO] Backup/restore using phpMyAdmin/SSH Darkblade Tutorials 0 07-31-2006 01:59 PM
Free File Hosts (Not Image or Site Hosts) gprime Off Topic 6 02-07-2006 11:24 PM

AdminFusion

All times are GMT +1. The time now is 01:30 AM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0 © 2005-2008 AdminFusion - All Rights Reserved


From:
Title:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37