Have a funny feeling I'm being stupid
Hi,
Can somebody help a newb? Here is my setup:
Server 2003 with IIS 6.0
PHP 5.3.0
MySQL 5.1.39-community
Squash Ladder 0.8.3.89
Now I follow the Instructions.txt to the letter, I get to the install.php part, I input my details and where the site is, when I click submit I get a load of insert into errors. now I know the Install notes say an older version of MySQL, is it my version of SQL that is the problem?
here is one of the error lines:
5: failure: this line generated an error!
>> INSERT INTO `WNNL_messages` VALUES ('', 1, '', '1254021406', 'Welcome to squash ladder PHP', '
the rest of the errors are similar, all with INSERT INTO errors
when I click on the site, the general layout is there, but there is no text and further more I cannot login as I can see in the error lines, these have not been inserted into the SQL tables. Am I just being stupid? can somebody help me?
regards
Wirewizard
Thanks for your reply Matt :)
I'm not sure if I have done something wrong, I tried the newest version on sourceforge, ran through the installer fine (which is much nicer I might add) got as far as I did before and this is what I got when it went through the setup process:
1: success
2: success
3: success
4: success
5: success
CREATE TABLE IF NOT EXISTS `site_messages` ( `message_id` int(11) NOT NULL auto_increment, `message_type` tinyint(4) NOT NULL default '1', `post_date` bigint(20) NOT NULL default '1168623000', `last_update` bigint(20) NOT NULL default '1168623000', `title` varchar(50) default '', `message_text` text default '', `expire` bigint(20) NOT NULL default '0', `exceptions` varchar(100) default '', PRIMARY KEY (`message_id`) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci
6: failure: this line generated an error!
|------->| CREATE TABLE IF NOT EXISTS `site_messages` ( `message_id` int(11) NOT NULL auto_increment, `message_type` tinyint(4) NOT NULL default '1', `post_date` bigint(20) NOT NULL default '1168623000', `last_update` bigint(20) NOT NULL default '1168623000', `title` varchar(50) default '', `message_text` text default '', `expire` bigint(20) NOT NULL default '0', `exceptions` varchar(100) default '', PRIMARY KEY (`message_id`) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci
7: success
8: success
9: success
INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES ('1', 1, 0, 1134388800, 'Support of the ladder', 'This software is provided free of charge. To support further development of the ladder please consider making a donation. Thank you.
\r\n\r\n\r\n\r\n
', 0, '')
10: failure: this line generated an error!
|------->| INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES ('1', 1, 0, 1134388800, 'Support of the ladder', 'This software is provided free of charge. To support further development of the ladder please consider making a donation. Thank you.
\r\n\r\n\r\n\r\n
', 0, '')
INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES (2, 5, 0, 1134388800, 'Data Protection', 'The ladder is hosted on a not for profit basis by squash-ladder.net. The data held is not processed \r\n for any purpose other than to allow individuals to participate in the ladder. The information held is Name and Email address. It is your choice if you wish to include any further contact details. They are stored \r\n in a password protected database. Your password to access the site is stored \r\n in the database in an encrypted form. The data is relatively safe but no guarantee \r\n is made regarding security. It is believed that these uses do not necessitate \r\n that the database and squash ladder be notified under the Data Protection Act, UK. Your ladder operator may need to register as a data operator depending on their country of operation. If you have any concerns about data protection or data security please discuss this with your ladder operator. ', 0, '')
11: failure: this line generated an error!
|------->| INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES (2, 5, 0, 1134388800, 'Data Protection', 'The ladder is hosted on a not for profit basis by squash-ladder.net. The data held is not processed \r\n for any purpose other than to allow individuals to participate in the ladder. The information held is Name and Email address. It is your choice if you wish to include any further contact details. They are stored \r\n in a password protected database. Your password to access the site is stored \r\n in the database in an encrypted form. The data is relatively safe but no guarantee \r\n is made regarding security. It is believed that these uses do not necessitate \r\n that the database and squash ladder be notified under the Data Protection Act, UK. Your ladder operator may need to register as a data operator depending on their country of operation. If you have any concerns about data protection or data security please discuss this with your ladder operator. ', 0, '')
INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES (3, 7, 0, 1134388800, 'Technical Support', '
Technical Information
\r\n
\r\n
There are no major issues currently. Some erors have been reported when users navigate the site with the forward and backward buttons. Please use the links on the site rather than browser forward/backward.
\r\n
This site requires version 4 browsers (Netscape 4.0 & Internet Explorer 4.0)
\r\n and better to work. If you have any problems with the site or have comments or suggestions regarding the site or squash ladder please visit the forums:
\r\n
http://deepblue.uk.net/site/forum/7
\r\n
', 0, '')
12: failure: this line generated an error!
|------->| INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES (3, 7, 0, 1134388800, 'Technical Support', '
Technical Information
\r\n
\r\n
There are no major issues currently. Some erors have been reported when users navigate the site with the forward and backward buttons. Please use the links on the site rather than browser forward/backward.
\r\n
This site requires version 4 browsers (Netscape 4.0 & Internet Explorer 4.0)
\r\n and better to work. If you have any problems with the site or have comments or suggestions regarding the site or squash ladder please visit the forums:
\r\n
http://deepblue.uk.net/site/forum/7
\r\n
', 0, '')
INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES (4, 1, 1168990123, 1168990123, 'New rating system', 'You will have noticed a points score appear next to player names on the rankings page (if logged in). This is a trial points rating system based on the classic Elo system. Players will be awarded points for winning and lose points for losing depending on how difficult the system calculates your opponent to be. It will take a few games to settle down the scoring system. Currently the rating is displayed for information purposes only but in future it will be possible to arrange the ladder ranking system around this points score.', 0, '')
13: failure: this line generated an error!
|------->| INSERT INTO `site_messages` (`message_id`, `message_type`, `post_date`, `last_update`, `title`, `message_text`, `expire`, `exceptions`) VALUES (4, 1, 1168990123, 1168990123, 'New rating system', 'You will have noticed a points score appear next to player names on the rankings page (if logged in). This is a trial points rating system based on the classic Elo system. Players will be awarded points for winning and lose points for losing depending on how difficult the system calculates your opponent to be. It will take a few games to settle down the scoring system. Currently the rating is displayed for information purposes only but in future it will be possible to arrange the ladder ranking system around this points score.', 0, '')
14: success
-- -- Dumping data for table `bypass_config` -- INSERT INTO `bypass_config` VALUES ('bypass', 'bypass', '', 'localhost', 604800, 259200, 0, 0, 'test', '1', 'test', '#B9CBCF', '#b9c5cf', '#E1E2E7', '#525a5c', 3, 0, 0, 0, 1, 1, 3, 4, '', 4, 4, 4, 7, 1, 2, 2, 3, 3, 4, 5, 6, 6, 6, '7', 'Other', 1, 'You are not logged in', '1', 'd/m/y', 4, '#E1E2E7', 0, 0, 113, 113, 113, 113, 15, 15, 113, 113, 0, 0, 0, 0, 0, 0, 0, 0, 0, '','', '', '', '', '')
15: failure: this line generated an error!
|------->| -- -- Dumping data for table `bypass_config` -- INSERT INTO `bypass_config` VALUES ('bypass', 'bypass', '', 'localhost', 604800, 259200, 0, 0, 'test', '1', 'test', '#B9CBCF', '#b9c5cf', '#E1E2E7', '#525a5c', 3, 0, 0, 0, 1, 1, 3, 4, '', 4, 4, 4, 7, 1, 2, 2, 3, 3, 4, 5, 6, 6, 6, '7', 'Other', 1, 'You are not logged in', '1', 'd/m/y', 4, '#E1E2E7', 0, 0, 113, 113, 113, 113, 15, 15, 113, 113, 0, 0, 0, 0, 0, 0, 0, 0, 0, '','', '', '', '', '')
16: success
17: success
18: success
19: success
I am out of ideas, if anyone can point me in the right direction, that would be spanky. I'm unsure if I've setup MySQL right as this is the first time I've set this up and I pretty much followed the wizards that come with it. PHPMyADMIN sems to be working ok with MySQL server, can create and delete the databases at will. I can see tables that were successful.
help! :)
Hi Wirewizard. I'm not sure I can explain this. I have just installed the sourceforge version on my windows laptop and it installed fine. It seems it's just having problems installing the site_messages table and adding data to the bypass_config table.
Can I just double check that your database was completely empty when you tried to run the install script and that you have chosen the utf8_unicode_ci collation and connection? The latter two are unlikely to affect this I think but worth checking on anyway.
How about getting the SQL window up in phpmyadmin and seeing if you can install the site_messages table manually with:
CREATE TABLE IF NOT EXISTS `site_messages` (
`message_id` int(11) NOT NULL auto_increment,
`message_type` tinyint(4) NOT NULL default '1',
`post_date` bigint(20) NOT NULL default '1168623000',
`last_update` bigint(20) NOT NULL default '1168623000',
`title` varchar(50) default '',
`message_text` text default '',
`expire` bigint(20) NOT NULL default '0',
`exceptions` varchar(100) default '',
PRIMARY KEY (`message_id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;and assuming the 'bypass_config' table is already created to try to add the line:
INSERT INTO `bypass_config` VALUES ('bypass', 'bypass', '', 'localhost', 604800, 259200, 0, 0, 'test', '1', 'test', '#B9CBCF', '#b9c5cf', '#E1E2E7', '#525a5c', 3, 0, 0, 0, 1, 1, 3, 4, '', 4, 4, 4, 7, 1, 2, 2, 3, 3, 4, 5, 6, 6, 6, '7', 'Other', 1, 'You are not logged in', '1', 'd/m/y', 4, '#E1E2E7', 0, 0, 113, 113, 113, 113, 15, 15, 113, 113, 0, 0, 0, 0, 0, 0, 0, 0, 0, '','', '', '', '', '');Matt
Hi Matt,
Sorry for my delayed reply, been a bit snowed under the last few days. I will have a go over the weekend and will post my results once I give it a go.
Thanks for all your help so far :)
Hi Matt,
Sorry, no go, the first command up there gives me the following in phpmyadmin:
#1101 - BLOB/TEXT column 'message_text' can't have a default value
the second command returns:
#1366 - Incorrect integer value: '' for column 'format' at row 1
I recreataed the database from scratch again with UTF8_unicode and attempted to install again from a fresh database/squash ladder web directory, I get the same error. also attempted to put in those commands again, no go.
Thanks for you help so far, really appreciated.
regards
Wirewizard
I can see what the problem is. I will upload corrected files to svn on sourceforge tonight. I think it probably best for you to try a fresh install with the new files. Pls let me know how you get on.
thanks,
matt
Just to confirm wirewizrd that revision 58 on svn should hopefully fix this install issue for you,
matt
thanks matt, I shall give this a go and let you know what happens
again, thank you for all your help so far :)
I'm really sorry, but that didn't work 100% either :( I'm down to 1 error.
-- -- Dumping data for table `bypass_config` -- INSERT INTO `bypass_config` VALUES ('bypass', 'bypass', '', 'localhost', 604800, 259200, 0, 0, 'test', '1', 'test', '#B9CBCF', '#b9c5cf', '#E1E2E7', '#525a5c', 3, 0, 0, 0, 1, 1, 3, 4, '', 4, 4, 4, 7, 1, 2, 2, 3, 3, 4, 5, 6, 6, 6, '7', 'Other', 1, 'You are not logged in', '1', 'd/m/y', 4, '#E1E2E7', 0, 0, 113, 113, 113, 113, 15, 15, 113, 113, 0, 0, 0, 0, 0, 0, 0, 0, 0, '','', '', '0', '', '')
15: failure: this line generated an error!
|------->| -- -- Dumping data for table `bypass_config` -- INSERT INTO `bypass_config` VALUES ('bypass', 'bypass', '', 'localhost', 604800, 259200, 0, 0, 'test', '1', 'test', '#B9CBCF', '#b9c5cf', '#E1E2E7', '#525a5c', 3, 0, 0, 0, 1, 1, 3, 4, '', 4, 4, 4, 7, 1, 2, 2, 3, 3, 4, 5, 6, 6, 6, '7', 'Other', 1, 'You are not logged in', '1', 'd/m/y', 4, '#E1E2E7', 0, 0, 113, 113, 113, 113, 15, 15, 113, 113, 0, 0, 0, 0, 0, 0, 0, 0, 0, '','', '', '0', '', '')
When i tryed to put the insert into command that is in that error it came back to the following:
#1366 - Incorrect integer value: '' for column 'advertise' at row 1This is the only error I'm receiving now. Also I tried to carry on through the rest of the setup, but it takes me to a /site_admin/ladder_install part of the website, and looking at the directory structure, this directory does not exist. Please, If I'm being a numpty, do feel completely free to tell me as I definately do feel like a muppet now lol.
Strange thing is all of the prechecks in the onetimesetup.php come back with ticks.
I do appreciate all of your help so far and apologise for any stupidity on my part. I'll definately be donating something to the project once I get this running :)
regards
Wirewizard
OK. Hopefully nearly there! Have uploaded to svn 2 changes that should avoid the latest sql error you have encountered.
Have you got apache mod rewrite installed? The directory structure is virtual so /site_admin/ladder_install doesn't actually exist. That page should display the page to create your ladders.
Come back with any further questions.
cheers,
matt
Success all the way this time :) I have found an IIS apache mod rewrite, installed it and as far as I can tell it is running (I did some checks in the troubleshooting and blocked all access to the site using a command) but the virtual directory still won't work... to be honest I am in the dark on how to set this up.
I am using ISAPI rewrite 3 lite found here
Has anybody used any IIS mod rewrites to make this work? I've been looking at tutorials and setups, but its a bit double dutch to me. I will play a bit more with the config and will let you know if I get this working :)
Thank you for all your effort so far, its working SQL/setup side now :) Just this mod rewrite...
Glad to hear the install worked.
I use http://www.wampserver.com/ on windows machine so you might try that as an alternative if you can't get your server running.
matt
saw the comment "installed ok on my WAMP laptop", could you provide a package that does just that ? I'm possibly interested in helping development.
thanks
Nick
Hi wirewizard,
I'd suggest not bothering with 0.8.x version as it has too many bugs. The 0.9.0 version can be obtained on the sourceforge site by subversion. It's quite stable and has a better installer.
Matt