Unstoppable Domains

MySql Help

Spaceship Spaceship
Watch
Xerox

Xerox

Account Closed
Impact
0
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','[URL={THUMBURL}][IMG]{IMAGEURL}[/IMG][/URL]','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?
 
Reply
0
0 Like
0 Thanks
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
AfternicAfternic
Sort by date Sort by points
Try:

/*!40101 SET CHARACTER SET 'latin1' */;
 
Reply
0
0 Like
0 Thanks
•••
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
#
 
Reply
0
0 Like
0 Thanks
•••
Log in or sign up to reply here.
Dynadot โ€” .com Registration $8.99Dynadot โ€” .com Registration $8.99

Similar threads

U
MYSQL error
4 replies
552 views
unknowngiver
U
B
Invalid default value on mysql.
6 replies
874 views
neroux
N
Eric
PostgreSQL
3 replies
761 views
Eric
Eric
Eric
Ok, I admit - I need help.
5 replies
960 views
Peter
Peter
nicedomain4sale
Need Mysql assistance
2 replies
501 views
nicedomain4sale
nicedomain4sale
Appraise.net

We're social

Escrow.com

New posts โž”

Spaceship

Auction activity โž”

Unstoppable Domains

How do you think a potential buyer first checks if your domain is for sale?

Polls of interest โž”

CryptoExchange.com

Hot this week โž”

Domain Recover

Community favorite โž”

Hot this month โž”

DomainEasy โ€” Payment Flexibility

Blog favorites

DomDB

  1. TheAvatar.io

    • Show Price

  2. bscq.com

    • Make Offer

  3. rosyclouds.ai

    • Make Offer

  4. mms.lat

    • Make Offer

  5. ppsy.com

    • Make Offer

  6. exotly.com

    • Make Offer

  7. AddictiveBrands.com

    • Make Offer

  8. 5Coin.org

    • Show Price

  9. TheDoing.com

    • Make Offer

  10. Finns.net

    • Make Offer
  • The sidebar remains visible by scrolling at a speed relative to the pageโ€™s height.
Back