MYSQL problem.

Josh-H Active Member

Messages:: 406

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 55

#1

Hello.

Here is the code for my install script:

<?php 
include ("config.php");

mysql_query("
CREATE TABLE `acppages` (
  `id` int(20) NOT NULL auto_increment,
  `pagefile` text collate latin1_general_ci NOT NULL,
  `pagename` text collate latin1_general_ci NOT NULL,
  `pageanchor` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;


INSERT INTO `acppages` VALUES (1, 'searchusers.php', 'searchusers', 'search users');
INSERT INTO `acppages` VALUES (2, 'listalldesigns.php', 'listdesigns', 'list designs');
INSERT INTO `acppages` VALUES (3, 'banusers.php', 'banusers', 'Ban Users');
INSERT INTO `acppages` VALUES (4, 'searchusers2.php', 'searchdesigners', '');
INSERT INTO `acppages` VALUES (5, 'editusers.php', 'editusers', '');
INSERT INTO `acppages` VALUES (6, 'edituseravatar.php', 'editavatars', '');
INSERT INTO `acppages` VALUES (7, 'deletecomments.php', 'deletecomments', '');


CREATE TABLE `comments` (
  `id` int(10) NOT NULL auto_increment,
  `message` text NOT NULL,
  `author` text NOT NULL,
  `date` text NOT NULL,
  `design` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `comments` VALUES (8, 'VGhpcyBpcyBteSBmYXZvdXJpdGUgbG9nbyB5b3VcJiMwMzk7dmUgbWFkZSBhbmQgaXRzIGRpZmZlcmVudCBpbiB0aGUgc2Vuc2UgdGhhdCBpdCBkb2VzblwmIzAzOTt0IGZvbGxvdyB5b3VyIHRyYWRpdGlvbmFsIFwmcXVvdDtzdHlsZVwmcXVvdDsuIEkgd291bGQgbGlrZSB0byBzZWUgaXQgaW1wbGVtZW50ZWQgaW50byBhIGRlc2lnbiBwb3NzaWJseSBhbHRob3VnaCBJIGZlZWwgdGhhdCBtYXkgYmUgZGlmZmljdWx0Lg==', 'Josh', '28.07.07', '17');

CREATE TABLE `designeravatars` (
  `id` int(20) NOT NULL auto_increment,
  `avatarlink` text character set latin1 collate latin1_general_ci NOT NULL,
  `designer` text character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

INSERT INTO `designeravatars` VALUES (9, '/845MTUwLmdpZg==150.gif', 'Sygon');
INSERT INTO `designeravatars` VALUES (10, '/153RFBhdmF0YXIuanBnDPavatar.jpg', 'Josh');
INSERT INTO `designeravatars` VALUES (12, '/541am9zaC5wbmc=josh.png', 'Josh-H');
INSERT INTO `designeravatars` VALUES (13, '/508U3Vuc2V0LmpwZw==Sunset.jpg', 'smerky');
INSERT INTO `designeravatars` VALUES (14, '/814OTcwLmpwZw==970.jpg', 'Dakuipje2');

CREATE TABLE `designers` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `dob` varchar(12) NOT NULL default '',
  `location` tinytext NOT NULL,
  `language` varchar(100) NOT NULL default '',
  `occupation` text NOT NULL,
  `passtime` varchar(100) NOT NULL default '',
  `band` varchar(100) NOT NULL default '',
  `website` varchar(150) NOT NULL default '',
  `ip` text NOT NULL,
  `gender` varchar(10) NOT NULL default '',
  `isadmin` char(1) NOT NULL default '',
  `isbanned` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `designers` VALUES (1, 'Sygon', '098f6bcd4621d373cade4e832627b4f6', 'afterthat07@hotmail.co.uk', '26..11.1992', 'London', 'English', 'Student', 'Dragonball Z', 'FOB', 'http://www.59codes.com', '127.0.0.1', 'Male', '', '');
INSERT INTO `designers` VALUES (3, 'Josh', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'jholder112233@aol.com', '02.02.1992', 'UK', 'English', 'Student', 'Wakeboarding', 'Paramore', 'http://designerpeak.com', '84.67.34.4', 'Male', '1', '');
INSERT INTO `designers` VALUES (4, 'Josh-H', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'jholder112233@aol.com', '02.02.1992', 'UK', 'English', 'Student', 'Web Designing', 'Paramore', 'http://designerpeak.com', '84.67.34.4', 'Male', '', '');
INSERT INTO `designers` VALUES (5, 'kruza', '04be094bb721369ca4f223613edd345f', 'ndubejunior12@msn.com', '10.10.1980', 'UK', 'English', 'Student', '', '', '', '90.199.192.122', 'male', '', '');
INSERT INTO `designers` VALUES (6, 'smerky', 'f0c08cfc0249be06cd9f591079e8ccb7', 'ndubejunior12@msn.com', '10.10.1980', 'UK', 'English', 'Student', 'dunno', 'dunno', 'dunno', '90.199.192.122', 'male', '', '');
INSERT INTO `designers` VALUES (7, 'Dakuipje', '341f28cbab7dba9c18deb6e3eef96f49', 'dakuipje@gmail.com', '13.05.1989', 'Almelo', 'Dutch', 'Webdesign', '', '', 'http://www.pix-hoster.com', '81.204.165.87', 'Male', '', '');
INSERT INTO `designers` VALUES (8, 'Dakuipje2', '341f28cbab7dba9c18deb6e3eef96f49', 'dakuipje@gmail.com', '13.05.1989', 'Almelo', 'Dutch', 'Webdesign', '', '', 'http://www.pix-hoster.com', '81.204.165.87', 'Male', '', '');


CREATE TABLE `designs` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `designer` text NOT NULL,
  `views` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `details` text NOT NULL,
  `download` char(3) NOT NULL default 'no',
  `link` text NOT NULL,
  `price` varchar(100) NOT NULL default '',
  `sale` char(3) NOT NULL default '',
  `inspiration` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;


INSERT INTO `designs` VALUES (10, 'Old DesignerPeak Layout', 'Josh', '89', '07.27.07', '2007-07-27', 'This is the original designerpeak layout before I went with the current one. ', 'yes', '351Joshnetwork.gif', '', '', '9');
INSERT INTO `designs` VALUES (19, 'AmbitionList.com', 'Josh', '34', '07.28.07', '2007-07-28', 'This is my design for homepage of my newly launching site; AmbitionList.com. AmbitionList is loosely based on social networking but with a unique feel as its focus is setting targets and fulfilling ambitions.', 'no', '765Joshambitionlist.jpg', '', '', '5');
INSERT INTO `designs` VALUES (17, '59Codes Logo Concept 1', 'Sygon', '68', '07.27.07', '2007-07-27', 'YUS', 'no', '448Sygonmain.gif', '', '', '8');
INSERT INTO `designs` VALUES (15, '59Codes Concept 1', 'Sygon', '42', '07.27.07', '2007-07-27', 'This was the original and the best by far.', 'no', '597Sygon59codes.jpg', '', '', '3');


CREATE TABLE `privatemessages` (
  `id` int(11) NOT NULL auto_increment,
  `author` tinytext NOT NULL,
  `message` text NOT NULL,
  `date` tinytext NOT NULL,
  `recipient` varchar(150) NOT NULL default '',
  `viewed` char(2) NOT NULL default '0',
  `title` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;



INSERT INTO `privatemessages` VALUES (2, 'Josh', 'nice. Just looking around a bit', '07.27.07', 'Sygon', '1', 'Hi');
INSERT INTO `privatemessages` VALUES (8, 'Josh-H', 'hkhkhklnkln', '07.31.07', 'Josh', '1', 'sfnkhjk');
INSERT INTO `privatemessages` VALUES (4, 'Josh', 'Ok Will do.\r\n\r\n', '07.27.07', 'Sygon', '1', 'Hi');



CREATE TABLE `usercppages` (
  `id` int(20) NOT NULL auto_increment,
  `pagefile` text character set latin1 collate latin1_general_ci NOT NULL,
  `pagename` text character set latin1 collate latin1_general_ci NOT NULL,
  `pageanchor` text character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `usercppages` VALUES (1, 'editprofile.php', 'editprofile', 'Edit Profile');
INSERT INTO `usercppages` VALUES (2, 'newmessage.php', 'newmessage', 'newmessage');
INSERT INTO `usercppages` VALUES (3, 'inbox.php', 'inbox', 'inbox');
INSERT INTO `usercppages` VALUES (4, 'deletemessage.php', 'deletemessage', 'deletemessage');
INSERT INTO `usercppages` VALUES (5, 'newdesign.php', 'newdesign', 'newdesign');
INSERT INTO `usercppages` VALUES (6, 'listdesigns.php', 'listdesigns', 'listdesigns');
INSERT INTO `usercppages` VALUES (7, 'deletedesign.php', 'deletedesign', 'deletedesign');
INSERT INTO `usercppages` VALUES (8, 'editdesign.php', 'editdesign', 'Edit Design');
") or die("could not install ".mysql_error()."");

?>

Code (markup):

The error I am getting is:

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 '; INSERT INTO `acppages` VALUES (1, 'searchusers.php', 'searchusers', 'sear' at line 7

Code (markup):

Could somebody help me sort this out please?

Josh-H, Aug 14, 2007 IP

aGig Well-Known Member

Messages:: 428

Likes Received:: 5

Best Answers:: 1

Trophy Points:: 118

#2

What version of MySQL are you running?

aGig, Aug 14, 2007 IP

Josh-H Active Member

Messages:: 406

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 55

#3

version 4.

Josh-H, Aug 14, 2007 IP

jakomo Well-Known Member

Messages:: 4,262

Likes Received:: 82

Best Answers:: 0

Trophy Points:: 138

#4

Hello,
Did you try to get rid this ENGINE=MyISAM; before the insert?

Best,
jakomo

jakomo, Aug 14, 2007 IP

Josh-H Active Member

Messages:: 406

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 55

#5

Still not working, here is the code now without the ENGINE=MyISAM;

Have I done that right?

<?php 
include ("config.php");

mysql_query("
CREATE TABLE `acppages` (
  `id` int(20) NOT NULL auto_increment,
  `pagefile` text collate latin1_general_ci NOT NULL,
  `pagename` text collate latin1_general_ci NOT NULL,
  `pageanchor` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
)   ;


INSERT INTO `acppages` VALUES (1, 'searchusers.php', 'searchusers', 'search users');
INSERT INTO `acppages` VALUES (2, 'listalldesigns.php', 'listdesigns', 'list designs');
INSERT INTO `acppages` VALUES (3, 'banusers.php', 'banusers', 'Ban Users');
INSERT INTO `acppages` VALUES (4, 'searchusers2.php', 'searchdesigners', '');
INSERT INTO `acppages` VALUES (5, 'editusers.php', 'editusers', '');
INSERT INTO `acppages` VALUES (6, 'edituseravatar.php', 'editavatars', '');
INSERT INTO `acppages` VALUES (7, 'deletecomments.php', 'deletecomments', '');


CREATE TABLE `comments` (
  `id` int(10) NOT NULL auto_increment,
  `message` text NOT NULL,
  `author` text NOT NULL,
  `date` text NOT NULL,
  `design` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
)    DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `comments` VALUES (8, 'VGhpcyBpcyBteSBmYXZvdXJpdGUgbG9nbyB5b3VcJiMwMzk7dmUgbWFkZSBhbmQgaXRzIGRpZmZlcmVudCBpbiB0aGUgc2Vuc2UgdGhhdCBpdCBkb2VzblwmIzAzOTt0IGZvbGxvdyB5b3VyIHRyYWRpdGlvbmFsIFwmcXVvdDtzdHlsZVwmcXVvdDsuIEkgd291bGQgbGlrZSB0byBzZWUgaXQgaW1wbGVtZW50ZWQgaW50byBhIGRlc2lnbiBwb3NzaWJseSBhbHRob3VnaCBJIGZlZWwgdGhhdCBtYXkgYmUgZGlmZmljdWx0Lg==', 'Josh', '28.07.07', '17');

CREATE TABLE `designeravatars` (
  `id` int(20) NOT NULL auto_increment,
  `avatarlink` text character set latin1 collate latin1_general_ci NOT NULL,
  `designer` text character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
)    DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

INSERT INTO `designeravatars` VALUES (9, '/845MTUwLmdpZg==150.gif', 'Sygon');
INSERT INTO `designeravatars` VALUES (10, '/153RFBhdmF0YXIuanBnDPavatar.jpg', 'Josh');
INSERT INTO `designeravatars` VALUES (12, '/541am9zaC5wbmc=josh.png', 'Josh-H');
INSERT INTO `designeravatars` VALUES (13, '/508U3Vuc2V0LmpwZw==Sunset.jpg', 'smerky');
INSERT INTO `designeravatars` VALUES (14, '/814OTcwLmpwZw==970.jpg', 'Dakuipje2');

CREATE TABLE `designers` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `dob` varchar(12) NOT NULL default '',
  `location` tinytext NOT NULL,
  `language` varchar(100) NOT NULL default '',
  `occupation` text NOT NULL,
  `passtime` varchar(100) NOT NULL default '',
  `band` varchar(100) NOT NULL default '',
  `website` varchar(150) NOT NULL default '',
  `ip` text NOT NULL,
  `gender` varchar(10) NOT NULL default '',
  `isadmin` char(1) NOT NULL default '',
  `isbanned` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
)    DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `designers` VALUES (1, 'Sygon', '098f6bcd4621d373cade4e832627b4f6', 'afterthat07@hotmail.co.uk', '26..11.1992', 'London', 'English', 'Student', 'Dragonball Z', 'FOB', 'http://www.59codes.com', '127.0.0.1', 'Male', '', '');
INSERT INTO `designers` VALUES (3, 'Josh', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'jholder112233@aol.com', '02.02.1992', 'UK', 'English', 'Student', 'Wakeboarding', 'Paramore', 'http://designerpeak.com', '84.67.34.4', 'Male', '1', '');
INSERT INTO `designers` VALUES (4, 'Josh-H', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'jholder112233@aol.com', '02.02.1992', 'UK', 'English', 'Student', 'Web Designing', 'Paramore', 'http://designerpeak.com', '84.67.34.4', 'Male', '', '');
INSERT INTO `designers` VALUES (5, 'kruza', '04be094bb721369ca4f223613edd345f', 'ndubejunior12@msn.com', '10.10.1980', 'UK', 'English', 'Student', '', '', '', '90.199.192.122', 'male', '', '');
INSERT INTO `designers` VALUES (6, 'smerky', 'f0c08cfc0249be06cd9f591079e8ccb7', 'ndubejunior12@msn.com', '10.10.1980', 'UK', 'English', 'Student', 'dunno', 'dunno', 'dunno', '90.199.192.122', 'male', '', '');
INSERT INTO `designers` VALUES (7, 'Dakuipje', '341f28cbab7dba9c18deb6e3eef96f49', 'dakuipje@gmail.com', '13.05.1989', 'Almelo', 'Dutch', 'Webdesign', '', '', 'http://www.pix-hoster.com', '81.204.165.87', 'Male', '', '');
INSERT INTO `designers` VALUES (8, 'Dakuipje2', '341f28cbab7dba9c18deb6e3eef96f49', 'dakuipje@gmail.com', '13.05.1989', 'Almelo', 'Dutch', 'Webdesign', '', '', 'http://www.pix-hoster.com', '81.204.165.87', 'Male', '', '');


CREATE TABLE `designs` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `designer` text NOT NULL,
  `views` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `details` text NOT NULL,
  `download` char(3) NOT NULL default 'no',
  `link` text NOT NULL,
  `price` varchar(100) NOT NULL default '',
  `sale` char(3) NOT NULL default '',
  `inspiration` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
)    DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;


INSERT INTO `designs` VALUES (10, 'Old DesignerPeak Layout', 'Josh', '89', '07.27.07', '2007-07-27', 'This is the original designerpeak layout before I went with the current one. ', 'yes', '351Joshnetwork.gif', '', '', '9');
INSERT INTO `designs` VALUES (19, 'AmbitionList.com', 'Josh', '34', '07.28.07', '2007-07-28', 'This is my design for homepage of my newly launching site; AmbitionList.com. AmbitionList is loosely based on social networking but with a unique feel as its focus is setting targets and fulfilling ambitions.', 'no', '765Joshambitionlist.jpg', '', '', '5');
INSERT INTO `designs` VALUES (17, '59Codes Logo Concept 1', 'Sygon', '68', '07.27.07', '2007-07-27', 'YUS', 'no', '448Sygonmain.gif', '', '', '8');
INSERT INTO `designs` VALUES (15, '59Codes Concept 1', 'Sygon', '42', '07.27.07', '2007-07-27', 'This was the original and the best by far.', 'no', '597Sygon59codes.jpg', '', '', '3');


CREATE TABLE `privatemessages` (
  `id` int(11) NOT NULL auto_increment,
  `author` tinytext NOT NULL,
  `message` text NOT NULL,
  `date` tinytext NOT NULL,
  `recipient` varchar(150) NOT NULL default '',
  `viewed` char(2) NOT NULL default '0',
  `title` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
)    DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;



INSERT INTO `privatemessages` VALUES (2, 'Josh', 'nice. Just looking around a bit', '07.27.07', 'Sygon', '1', 'Hi');
INSERT INTO `privatemessages` VALUES (8, 'Josh-H', 'hkhkhklnkln', '07.31.07', 'Josh', '1', 'sfnkhjk');
INSERT INTO `privatemessages` VALUES (4, 'Josh', 'Ok Will do.\r\n\r\n', '07.27.07', 'Sygon', '1', 'Hi');



CREATE TABLE `usercppages` (
  `id` int(20) NOT NULL auto_increment,
  `pagefile` text character set latin1 collate latin1_general_ci NOT NULL,
  `pagename` text character set latin1 collate latin1_general_ci NOT NULL,
  `pageanchor` text character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
)    DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `usercppages` VALUES (1, 'editprofile.php', 'editprofile', 'Edit Profile');
INSERT INTO `usercppages` VALUES (2, 'newmessage.php', 'newmessage', 'newmessage');
INSERT INTO `usercppages` VALUES (3, 'inbox.php', 'inbox', 'inbox');
INSERT INTO `usercppages` VALUES (4, 'deletemessage.php', 'deletemessage', 'deletemessage');
INSERT INTO `usercppages` VALUES (5, 'newdesign.php', 'newdesign', 'newdesign');
INSERT INTO `usercppages` VALUES (6, 'listdesigns.php', 'listdesigns', 'listdesigns');
INSERT INTO `usercppages` VALUES (7, 'deletedesign.php', 'deletedesign', 'deletedesign');
INSERT INTO `usercppages` VALUES (8, 'editdesign.php', 'editdesign', 'Edit Design');
") or die("could not install ".mysql_error()."");

?>

Code (markup):

Josh-H, Aug 14, 2007 IP

void Peon

Messages:: 119

Likes Received:: 9

Best Answers:: 0

Trophy Points:: 0

#6

mysql_query() doesn't support multiple SQL statements. You'll have to separate the query into multiple smaller queries - ending at each semi-colon, i.e. each INSERT, CREATE etc. needs it's own mysql_query() call.

If you're using phpMyAdmin then you can paste the query into a query window and it'll work fine.

If you're using PHP5 you can use mysqli - mysqli_multi_query()

void, Aug 14, 2007 IP

Josh-H Active Member

Messages:: 406

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 55

#7

Ah. Thanks void. I'll try that asap.

Josh-H, Aug 14, 2007 IP

PHPGator Banned

Messages:: 4,437

Likes Received:: 133

Best Answers:: 0

Trophy Points:: 260

#9

void is correct, you will need to get ride of the mysql_query, and <?php tags, as well as the include(); I was thinking the exact same thing as I was looking at it wondering why you would use PHP to try to insert this. phpMyAdmin will be your friend here!

PHPGator, Aug 14, 2007 IP

mikeloring Guest

Messages:: 21

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#10

i hate installation scripts =( i've been to lazy to write mine for the last week!

but yes, using PHPMyAdmin will make your life wonderful. i love the SQL TextBox =)

mikeloring, Aug 14, 2007 IP

Josh-H Active Member

Messages:: 406

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 55

#11

I need an installation script though Otherwise I would certainly use phpmyadmin. But a commercial script needs an installation really.

Josh-H, Aug 15, 2007 IP

Log in or Sign up

MYSQL problem.

Josh-H Active Member

aGig Well-Known Member

Josh-H Active Member

jakomo Well-Known Member

Josh-H Active Member

void Peon

Josh-H Active Member

PHPGator Banned

mikeloring Guest

Josh-H Active Member

Useful Searches