[advanced search]
 

Go Back   NamePros.com > Discussion > Web Design & Development > Programming

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.


Closed Thread
 
LinkBack Thread Tools
Old 12-22-2005, 12:10 PM   #1 (permalink)
Account Suspended
 
Xerox's Avatar
 
Join Date: Nov 2005
Posts: 47
4.75 NP$ (Donate)

Xerox is an unknown quantity at this point


MySql Help

Hello.
I am installing a script taht requires me to import the sql file to PhpMyAdmin

here is the file
Code:
# MySQL-Front 3.2  (Build 2.16)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET '' */;


# Host: localhost    Database: image
# ------------------------------------------------------
# Server version 4.0.20a-nt

#
# Table structure for table coppon
#

CREATE TABLE `coppon` (
  `id` int(10) NOT NULL auto_increment,
  `coppon` varchar(100) NOT NULL default '',
  `used` tinyint(1) NOT NULL default '0',
  `uid` int(10) NOT NULL default '0',
  `credits` int(10) NOT NULL default '0',
  `ip` varchar(100) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Table structure for table groups
#

CREATE TABLE `groups` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `bandwidth` int(6) default NULL,
  `sizelimit` int(10) default NULL,
  `filetype` varchar(255) default NULL,
  `credits` int(6) default NULL,
  `common` tinyint(1) default '0',
  `applet` tinyint(1) default '0',
  `thumb` tinyint(1) default NULL,
  `fee` varchar(20) default '0',
  `maxfiles` int(10) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table groups
#

INSERT INTO `groups` VALUES (1,'basic',500000,800000,'gif,jpeg,jpg,png,bmp,tif',20,1,1,1,'0',10);
INSERT INTO `groups` VALUES (2,'Golden',5000000,555555,'jpg,png,tiff,tif,gif,bmp',200,1,1,1,'5.00',100);
INSERT INTO `groups` VALUES (5,'Super',1111111111,6000000,'jpg,zip,gif,png,tif,tiff,png',500,1,1,1,'10',100);

#
# Table structure for table images
#

CREATE TABLE `images` (
  `id` int(10) NOT NULL auto_increment,
  `file` varchar(250) NOT NULL default '',
  `name` varchar(250) NOT NULL default '',
  `uid` int(10) default '0',
  `width` int(10) NOT NULL default '0',
  `height` int(10) NOT NULL default '0',
  `size` int(10) NOT NULL default '0',
  `ip` varchar(20) default NULL,
  `extra` varchar(250) NOT NULL default '',
  `time` int(12) NOT NULL default '0',
  `views` int(10) default '0',
  `bandwidth` int(10) default '0',
  `lastview` int(11) default NULL,
  `server_id` int(11) default NULL,
  `deleted` tinyint(1) default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table images
#

#
# Table structure for table links
#

CREATE TABLE `links` (
  `id` tinyint(6) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `code` mediumtext NOT NULL,
  `filetype` mediumtext NOT NULL,
  `enable` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table links
#

INSERT INTO `links` VALUES (1,'Auction/Website Code','<img src=\"{IMAGEURL}\" alt=\"Free Image Hosting at\" />','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (2,'Clickable Auction/Website Code','<a href=\"{IMAGEURL}\" target=\"_blank\"><img src=\"{THUMBURL}\" alt=\"Free Image Hosting at\" /></a>','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (3,'Clickable Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (4,'Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (6,'Direct Linking Code','{IMAGEURL}','jpg,bmp,jpeg,png,tiff,gif,zip,tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (7,'Direct Thumb Linking Code','{THUMBURL}','jpg,jpeg,png,tiff,gif,bmp',1);
INSERT INTO `links` VALUES (8,'Show your image to your friends','{ADSURL}','jpg,jpeg,tiff,png,bmp,gif,zip,tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (9,'Show your Flash!','<embed src=\"{IMAGEURL}\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"{WIDTH}\" height=\"{HEIGHT}\"></embed>   ','swf',1);

#
# Table structure for table payment
#

CREATE TABLE `payment` (
  `pay_id` int(11) unsigned NOT NULL auto_increment,
  `txn_id` varchar(100) default NULL,
  `uid` int(11) default NULL,
  `descr` varchar(255) default NULL,
  `fee` int(11) default NULL,
  `credits` int(11) default NULL,
  `date` int(11) default NULL,
  PRIMARY KEY  (`pay_id`)
) TYPE=MyISAM;

#
# Dumping data for table payment
#

#
# Table structure for table server
#

CREATE TABLE `server` (
  `server_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `domain` varchar(255) default NULL,
  `webspace` int(11) default NULL,
  `hosted` int(11) default NULL,
  `ftp` varchar(255) default NULL,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `path` text,
  `enabled` tinyint(1) default '0',
  PRIMARY KEY  (`server_id`)
) TYPE=MyISAM;

#
# Dumping data for table server
#

INSERT INTO `server` VALUES (1,'127.0.0.1/server','127.0.0.1/server',24978907,156,'','','','',1);

#
# Table structure for table setting
#

CREATE TABLE `setting` (
  `filetype` varchar(250) NOT NULL default '',
  `sizelimit` int(10) default NULL,
  `maxbandwidthbyday` varchar(25) NOT NULL default '0',
  `adminemail` varchar(100) NOT NULL default '',
  `credit` tinyint(6) default NULL,
  `maxfiles` int(10) default '1',
  `applet` tinyint(1) default '1',
  `common` tinyint(1) default '1',
  `t_width` int(11) default '100',
  `t_height` int(11) default '100',
  `thumb` tinyint(1) default '0',
  `validate` tinyint(1) default '0',
  `pagenum` tinyint(4) default '10',
  `showmode` tinyint(1) NOT NULL default '0',
  `banip` mediumtext,
  `sitename` varchar(200) default NULL,
  `server` varchar(11) default '0',
  `minviews` int(11) default NULL,
  `deldays` int(6) default NULL,
  `admin` varchar(32) default NULL,
  `pass` varchar(255) default NULL,
  `sandbox` tinyint(4) default '1',
  `paypal_address` varchar(255) default NULL,
  `email_links` mediumtext,
  `email_reg` mediumtext,
  `email_purchase` mediumtext,
  `email_getpassword` mediumtext
) TYPE=MyISAM;

#
# Dumping data for table setting
#

INSERT INTO `setting` VALUES ('jpg,zip,tif,bmp,jpeg,gif,png,swf,tiff',6000000,122220000,'',1,10,1,1,150,150,1,1,10,1,'','site','0',1,30,'admin','123',1,'changeme@emailcom','{linkcode}','    \r\nEmail:{username}\r\nPassword:{password}\r\n\r\nYou need to actvate your Account first:\r\n<a href=\"{validate_url}\">Acivate Account</a>\r\nor Paste below url in your browser:\r\n{validate_url}','\r\n{process_details}','Email:{username}\r\nPassword:{password}');

#
# Table structure for table tmpuser
#

CREATE TABLE `tmpuser` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `sess` varchar(32) default NULL,
  `type` int(1) default '0',
  `gid` int(6) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table tmpuser
#

#
# Table structure for table users
#

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `email` varchar(30) default NULL,
  `pics` int(10) default '0',
  `bandwidth` int(10) default '0',
  `webspace` int(10) default '0',
  `credits` int(10) default '0',
  `gid` tinyint(4) default NULL,
  `status` tinyint(4) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table users
#

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
and i am getting this error
Code:
  SQL query:

/*!40101 SET CHARACTER SET '' */

MySQL said: Documentation
#1115 - Unknown character set: ''
Can anyone help me?

Ok i have removed the line and it worked.
Will this make a error im my Script?
Xerox is offline  
Old 12-22-2005, 04:09 PM   #2 (permalink)
mch
NamePros Regular
 
Join Date: Nov 2005
Location: EU
Posts: 248
99.25 NP$ (Donate)

mch is on a distinguished road


Try:

/*!40101 SET CHARACTER SET 'latin1' */;
mch is offline  
Old 12-22-2005, 09:53 PM   #3 (permalink)
jdk
Senior Member
 
jdk's Avatar
 
Join Date: Jul 2004
Location: Florida
Posts: 1,223
306.40 NP$ (Donate)

jdk is a name known to alljdk is a name known to alljdk is a name known to alljdk is a name known to alljdk is a name known to alljdk is a name known to all


Try this:

Code:
# Host: localhost    Database: image
# ------------------------------------------------------
# Server version 4.0.20a-nt

#
# Table structure for table coppon
#

CREATE TABLE `coppon` (
  `id` int(10) NOT NULL auto_increment,
  `coppon` varchar(100) NOT NULL default '',
  `used` tinyint(1) NOT NULL default '0',
  `uid` int(10) NOT NULL default '0',
  `credits` int(10) NOT NULL default '0',
  `ip` varchar(100) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Table structure for table groups
#

CREATE TABLE `groups` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `bandwidth` int(6) default NULL,
  `sizelimit` int(10) default NULL,
  `filetype` varchar(255) default NULL,
  `credits` int(6) default NULL,
  `common` tinyint(1) default '0',
  `applet` tinyint(1) default '0',
  `thumb` tinyint(1) default NULL,
  `fee` varchar(20) default '0',
  `maxfiles` int(10) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table groups
#

INSERT INTO `groups` VALUES (1,'basic',500000,800000,'gif,jpeg,jpg,png,bmp,tif  ',20,1,1,1,'0',10);
INSERT INTO `groups` VALUES (2,'Golden',5000000,555555,'jpg,png,tiff,tif,gif,b  mp',200,1,1,1,'5.00',100);
INSERT INTO `groups` VALUES (5,'Super',1111111111,6000000,'jpg,zip,gif,png,tif  ,tiff,png',500,1,1,1,'10',100);

#
# Table structure for table images
#

CREATE TABLE `images` (
  `id` int(10) NOT NULL auto_increment,
  `file` varchar(250) NOT NULL default '',
  `name` varchar(250) NOT NULL default '',
  `uid` int(10) default '0',
  `width` int(10) NOT NULL default '0',
  `height` int(10) NOT NULL default '0',
  `size` int(10) NOT NULL default '0',
  `ip` varchar(20) default NULL,
  `extra` varchar(250) NOT NULL default '',
  `time` int(12) NOT NULL default '0',
  `views` int(10) default '0',
  `bandwidth` int(10) default '0',
  `lastview` int(11) default NULL,
  `server_id` int(11) default NULL,
  `deleted` tinyint(1) default '0',
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table images
#

#
# Table structure for table links
#

CREATE TABLE `links` (
  `id` tinyint(6) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `code` mediumtext NOT NULL,
  `filetype` mediumtext NOT NULL,
  `enable` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table links
#

INSERT INTO `links` VALUES (1,'Auction/Website Code','<img src=\"{IMAGEURL}\" alt=\"Free Image Hosting at\" />','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (2,'Clickable Auction/Website Code','<a href=\"{IMAGEURL}\" target=\"_blank\"><img src=\"{THUMBURL}\" alt=\"Free Image Hosting at\" /></a>','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (3,'Clickable Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (4,'Forum Code\r\n','[IMG]{IMAGEURL}[/IMG]','jpg,jpeg,png,gif,bmp,tiff',1);
INSERT INTO `links` VALUES (6,'Direct Linking Code','{IMAGEURL}','jpg,bmp,jpeg,png,tiff,gif,zip,  tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (7,'Direct Thumb Linking Code','{THUMBURL}','jpg,jpeg,png,tiff,gif,bmp',1);  
INSERT INTO `links` VALUES (8,'Show your image to your friends','{ADSURL}','jpg,jpeg,tiff,png,bmp,gif,zip  ,tar,gz,txt,swf',1);
INSERT INTO `links` VALUES (9,'Show your Flash!','<embed src=\"{IMAGEURL}\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"{WIDTH}\" height=\"{HEIGHT}\"></embed>   ','swf',1);

#
# Table structure for table payment
#

CREATE TABLE `payment` (
  `pay_id` int(11) unsigned NOT NULL auto_increment,
  `txn_id` varchar(100) default NULL,
  `uid` int(11) default NULL,
  `descr` varchar(255) default NULL,
  `fee` int(11) default NULL,
  `credits` int(11) default NULL,
  `date` int(11) default NULL,
  PRIMARY KEY  (`pay_id`)
) TYPE=MyISAM;

#
# Dumping data for table payment
#

#
# Table structure for table server
#

CREATE TABLE `server` (
  `server_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `domain` varchar(255) default NULL,
  `webspace` int(11) default NULL,
  `hosted` int(11) default NULL,
  `ftp` varchar(255) default NULL,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `path` text,
  `enabled` tinyint(1) default '0',
  PRIMARY KEY  (`server_id`)
) TYPE=MyISAM;

#
# Dumping data for table server
#

INSERT INTO `server` VALUES (1,'127.0.0.1/server','127.0.0.1/server',24978907,156,'','','','',1);

#
# Table structure for table setting
#

CREATE TABLE `setting` (
  `filetype` varchar(250) NOT NULL default '',
  `sizelimit` int(10) default NULL,
  `maxbandwidthbyday` varchar(25) NOT NULL default '0',
  `adminemail` varchar(100) NOT NULL default '',
  `credit` tinyint(6) default NULL,
  `maxfiles` int(10) default '1',
  `applet` tinyint(1) default '1',
  `common` tinyint(1) default '1',
  `t_width` int(11) default '100',
  `t_height` int(11) default '100',
  `thumb` tinyint(1) default '0',
  `validate` tinyint(1) default '0',
  `pagenum` tinyint(4) default '10',
  `showmode` tinyint(1) NOT NULL default '0',
  `banip` mediumtext,
  `sitename` varchar(200) default NULL,
  `server` varchar(11) default '0',
  `minviews` int(11) default NULL,
  `deldays` int(6) default NULL,
  `admin` varchar(32) default NULL,
  `pass` varchar(255) default NULL,
  `sandbox` tinyint(4) default '1',
  `paypal_address` varchar(255) default NULL,
  `email_links` mediumtext,
  `email_reg` mediumtext,
  `email_purchase` mediumtext,
  `email_getpassword` mediumtext
) TYPE=MyISAM;

#
# Dumping data for table setting
#

INSERT INTO `setting` VALUES ('jpg,zip,tif,bmp,jpeg,gif,png,swf,tiff',6000000,1  22220000,'',1,10,1,1,150,150,1,1,10,1,'','site','0  ',1,30,'admin','123',1,'changeme@emailcom','{linkc  ode}','    \r\nEmail:{username}\r\nPassword:{password}\r\n\r\  nYou need to actvate your Account first:\r\n<a href=\"{validate_url}\">Acivate Account</a>\r\nor Paste below url in your browser:\r\n{validate_url}','\r\n{process_details}  ','Email:{username}\r\nPassword:{password}');

#
# Table structure for table tmpuser
#

CREATE TABLE `tmpuser` (
  `id` int(6) unsigned NOT NULL auto_increment,
  `sess` varchar(32) default NULL,
  `type` int(1) default '0',
  `gid` int(6) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table tmpuser
#

#
# Table structure for table users
#

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `email` varchar(30) default NULL,
  `pics` int(10) default '0',
  `bandwidth` int(10) default '0',
  `webspace` int(10) default '0',
  `credits` int(10) default '0',
  `gid` tinyint(4) default NULL,
  `status` tinyint(4) default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table users
#
__________________
All bids are valid for 24 hours unless otherwise stated.
jdk is offline  
Closed Thread


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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Great Scripts for Sale With Resale Rights! Zeeble Scripts For Sale 20 01-04-2006 01:39 AM
MySQL Tips shahid_146 Webmaster Tutorials 4 10-18-2005 12:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows deadserious Webmaster Tutorials 35 09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL. abdulmueid Webmaster Tutorials 16 08-27-2005 08:17 AM
Tutorial: Getting Started With MySQL (The Basics) deadserious Webmaster Tutorials 3 04-18-2004 01:17 PM

Site Sponsors
Advertise your business at NamePros

All times are GMT -7. The time now is 05:27 AM.


Powered by: vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Template-Modifications by TMS
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios

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 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85