Username:    Password:        Click Here To Signup     Forgotten Password
Main Menu
Online
Members: 0

Guests: 18

178.255.x.x lgsl
185.220.x.x signup
35.0.x.x forum
35.173.x.x rss
42.115.x.x news
46.229.x.x forum
46.229.x.x forum
46.229.x.x forum
46.229.x.x forum
46.229.x.x forum
46.229.x.x dilbertplus
46.229.x.x forum
46.229.x.x forum
46.229.x.x forum
46.4.x.x forum
54.234.x.x forum
60.53.x.x forum
78.46.x.x forum

Last Seen

mrstipfan Wed 19:48
Gagi2 Mon 16:30
EFiNST0RM Sun 15:39
85filip58 Sun 12:14
brlight Tue 04:18

Newest Members

Forums
Creating Tables in phpMyadmin
LuG
Sun Sep 13 2009, 11:55AM
Posts: 2
Joined: Sun Sep 13 2009, 11:41AM
Registered Member #5416
I am installing lgslv 5.5 on a RavenNuke server

I receive this error Everytime i go in to create the tables through phpMyadmin

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0041 sec)

CREATE TABLE `nuke_lgsl` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`type` VARCHAR( 50 ) NOT NULL DEFAULT '',
`ip` VARCHAR( 255 ) NOT NULL DEFAULT '',
`c_port` VARCHAR( 5 ) NOT NULL DEFAULT '0',
`q_port` VARCHAR( 5 ) NOT NULL DEFAULT '0',
`s_port` VARCHAR( 5 ) NOT NULL DEFAULT '0',
`zone` TINYINT( 1 ) NOT NULL DEFAULT '0',
`disabled` TINYINT( 1 ) NOT NULL DEFAULT '0',
`comment` VARCHAR( 255 ) NOT NULL DEFAULT '',
`status` TINYINT( 1 ) NOT NULL DEFAULT '0',
`cache` TEXT NOT NULL ,
`cache_time` TEXT NOT NULL ,
PRIMARY KEY ( `id` ) ) TYPE = MYISAM ;


I am using lgsl_install_phpnuke_for_old_mysql.sql
If i use lgsl_install_phpnuke.sql phpMyadmin times out
Website
Rich
Sun Sep 13 2009, 01:44PM
Posts: 1717
Joined: Wed Nov 26 2003, 04:30PM

You should avoid using the 'old' version.

Make sure have selected your nuke database first, then goto the Import tab, and select the location of the .SQL file.
Website
LuG
Sun Sep 13 2009, 02:12PM
Posts: 2
Joined: Sun Sep 13 2009, 11:41AM
Registered Member #5416
i did use the old version and have selected my database...that is all coming from that database with those errors. I have deleted it the tables several times with the same resultWhen i use the new version my phpmyadmin actually times out trying to create teh tables for some reason. I have never seen that before.
Website
Rich
Sun Sep 13 2009, 07:02PM
Posts: 1717
Joined: Wed Nov 26 2003, 04:30PM

Very bizarre, I can only think its some sort of MySQL bug.

Have you tried copying the contents of the .SQL file, and pasting it into the 'Query' tab of phpMyAdmin.

The other thing you can try is curtting out the columns, so you just have:

CREATE TABLE `nuke_lgsl` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT,
PRIMARY KEY ( `id` ) ) TYPE = MYISAM;

And see if you still get the same problem, if not, adding back the lines one by one until you find the cause.
Website
 

Jump:     Back to top


You are not logged in - Click Here To Signup

Username:    Password:   

Mini Buttons

.... © GreyCube.com - Richard Perry - Powered by e107.org