Page 1 of 1

SQL Error after Installation

Posted: Sun Dec 21, 2008 4:53 pm
by JPamplin
After installing AutoMOD on a otherwise unmodded 3.0.4 installation, I get this when clicking on the AutoMOD tab:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'riversidecomm_install_1211047698.phpbb_mods' doesn't exist [1146]

SQL

SELECT mod_id, mod_name FROM phpbb_mods ORDER BY mod_name ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_mods.php
LINE: 238
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_mods.php
LINE: 216
CALL: acp_mods->list_installed()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_mods->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Anyone? Thanks for the help.

JP

Re: SQL Error after Installation

Posted: Sun Dec 21, 2008 4:56 pm
by A_Jelly_Doughnut
The installer didn't complete successfully for some reason. Can you tell me what version of MySQL you are running (from the front page of the phpBB admin panel)?

Running this SQL query with a tool like phpMyAdmin should resolve the problem

Code: Select all

CREATE TABLE phpbb_mods (
	mod_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	mod_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	mod_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	mod_dependencies mediumblob NOT NULL,
	mod_name blob NOT NULL,
	mod_description blob NOT NULL,
	mod_version varbinary(25) DEFAULT '' NOT NULL,
	mod_author_notes blob NOT NULL,
	mod_author_name blob NOT NULL,
	mod_author_email blob NOT NULL,
	mod_author_url blob NOT NULL,
	mod_actions mediumblob NOT NULL,
	mod_languages blob NOT NULL,
	mod_template blob NOT NULL,
	mod_path blob NOT NULL,
	PRIMARY KEY (mod_id)

Re: SQL Error after Installation

Posted: Sun Dec 21, 2008 5:21 pm
by JPamplin
Certainly:

MySQL 5.0.51a-log

I'll try that query in phpmyAdmin and see if that doesn't help. I'll update this afterwards.

Thanks! JP

Re: SQL Error after Installation

Posted: Sun Dec 21, 2008 5:25 pm
by JPamplin
OK, phpMyAdmin isn't liking your query either:

Code: Select all

Error

SQL query:

CREATE TABLE phpbb_mods(
mod_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
mod_active tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
mod_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL ,
mod_dependencies mediumblob NOT NULL ,
mod_name blob NOT NULL ,
mod_description blob NOT NULL ,
mod_version varbinary( 25 ) DEFAULT '' NOT NULL ,
mod_author_notes blob NOT NULL ,
mod_author_name blob NOT NULL ,
mod_author_email blob NOT NULL ,
mod_author_url blob NOT NULL ,
mod_actions mediumblob NOT NULL ,
mod_languages blob NOT NULL ,
mod_template blob NOT NULL ,
mod_path blob NOT NULL ,
PRIMARY KEY ( mod_id )

MySQL said: Documentation
#1064 - 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 '' at line 17 
There's definitely not a phpBB_mods database in the Joomla tables. I am assuming this is why it failed. are there any other tables created by the install script? I'll probably need to recreate those as well.

thanks!

JP

Re: SQL Error after Installation

Posted: Sun Dec 21, 2008 5:29 pm
by A_Jelly_Doughnut
Ok, this is the proper query for MySQL 5.x.

Code: Select all

CREATE TABLE phpbb_mods (
	mod_id mediumint(8) UNSIGNED NOT NULL auto_increment,
	mod_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
	mod_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
	mod_dependencies mediumtext NOT NULL,
	mod_name varchar(100) DEFAULT '' NOT NULL,
	mod_description text NOT NULL,
	mod_version varchar(25) DEFAULT '' NOT NULL,
	mod_author_notes text NOT NULL,
	mod_author_name varchar(100) DEFAULT '' NOT NULL,
	mod_author_email varchar(100) DEFAULT '' NOT NULL,
	mod_author_url varchar(100) DEFAULT '' NOT NULL,
	mod_actions mediumtext NOT NULL,
	mod_languages varchar(255) DEFAULT '' NOT NULL,
	mod_template varchar(255) DEFAULT '' NOT NULL,
	mod_path varchar(255) DEFAULT '' NOT NULL,
	PRIMARY KEY (mod_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
The other query may have complained because it was missing the semicolon at the end. This was a copy & paste error on my part.

Re: SQL Error after Installation

Posted: Sun Dec 21, 2008 5:30 pm
by RMcGirr83
Is your table prefix phpbb_ ?
There's definitely not a phpBB_mods database in the Joomla tables
Huh? What does Joomla have to do with this?

Re: SQL Error after Installation

Posted: Sun Dec 21, 2008 5:57 pm
by JPamplin
Whoops, ignore that message. Trying to apply to the wrong tables. Sorry. Will get back to you on the SQL script.

JP

UPDATE: OK, table was created successfully and the AutoMOD area is showing up correctly. Now to just figure out the best way to configure it (I'm assuming "Compressed File Download" & .ZIP are the best choices). I'm off to read the installing MODs guide to figure out how to proceed.

Thanks again!

JP

Re: SQL Error after Installation

Posted: Tue Dec 30, 2008 11:31 pm
by kraski
Hi!

After installation I expirienced the same Error, I tried A_Jelly_Doughnut's both queries however nothing changed I'm still getting the same error.

My Mysql version: 5.0.51a-community

Code: Select all

SQL ERROR [ mysql4 ]

Table 'kraski_pp31.pp3_mods' doesn't exist [1146]

SQL

SELECT mod_id, mod_name FROM pp3_mods ORDER BY mod_name ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_mods.php
LINE: 238
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_mods.php
LINE: 216
CALL: acp_mods->list_installed()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_mods->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Re: SQL Error after Installation

Posted: Wed Dec 31, 2008 4:19 am
by DavidIQ
That's because your tables are all pp3_ so now you have a phpbb_mods table instead of a pp3_mods table. You'll need to change AJD's query to reflect the table prefix you have (pp3_).