Hello, I have a question. I have installed the script on my website. and I am running into a problem with logging in.
I am not too good with mysql databases, I am still learning. this is most likely an error on my side. But when I go to login I get this error:
------------------------------------------------------------------
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/content/r/a/d/radiofuckers/html/cobra/index.php on line 13
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/content/r/a/d/radiofuckers/html/cobra/index.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at /home/content/r/a/d/radiofuckers/html/cobra/index.php:13) in /home/content/r/a/d/radiofuckers/html/cobra/index.php on line 21
-------------------------------------------------------------------
I know that the errors are from the "ID" and "admin" tables of the database, is there something I need to fix on the tables?
This is the MYSQL table structure I have setup, correct me if any of this is wrong:
-------------------------------------------------------------------------
CREATE TABLE `members` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(30) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`age` int(2) default '0',
`egeninfo` text,
`MF` enum('M','F') default NULL,
`admin` int(1) NOT NULL default '0',
`favgrupp` text NOT NULL,
`favsong` text NOT NULL,
`favradio` text NOT NULL,
`lastname` text NOT NULL,
`bild` text NOT NULL,
`live` text NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `favgrupp` (`favgrupp`,`favsong`,`favradio`),
FULLTEXT KEY `lastname` (`lastname`,`bild`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
----------------------------------------------------------------
Welcome to Help
Hello, I have a question. I have installed the script on my website. and I am running into a problem with logging in.
I am not too good with mysql databases, I am still learning. this is most likely an error on my side. But when I go to login I get this error:
------------------------------------------------------------------
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/content/r/a/d/radiofuckers/html/cobra/index.php on line 13
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 3 in /home/content/r/a/d/radiofuckers/html/cobra/index.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at /home/content/r/a/d/radiofuckers/html/cobra/index.php:13) in /home/content/r/a/d/radiofuckers/html/cobra/index.php on line 21
-------------------------------------------------------------------
I know that the errors are from the "ID" and "admin" tables of the database, is there something I need to fix on the tables?
This is the MYSQL table structure I have setup, correct me if any of this is wrong:
-------------------------------------------------------------------------
CREATE TABLE `members` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(30) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`age` int(2) default '0',
`egeninfo` text,
`MF` enum('M','F') default NULL,
`admin` int(1) NOT NULL default '0',
`favgrupp` text NOT NULL,
`favsong` text NOT NULL,
`favradio` text NOT NULL,
`lastname` text NOT NULL,
`bild` text NOT NULL,
`live` text NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `favgrupp` (`favgrupp`,`favsong`,`favradio`),
FULLTEXT KEY `lastname` (`lastname`,`bild`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
----------------------------------------------------------------
The script can be found at: http://www.radiofuckers.com/cobra
Thanks for all your help!