SQL Error after Installation

Archive of support for the automated MOD installation tool codenamed "Blinky". For support questions regarding AutoMOD please visit here.
Get Involved
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: IF YOU NEED SUPPORT FOR AUTOMOD PLEASE VISIT THE APPROPRIATE LOCATION HERE.
Locked
JPamplin
Registered User
Posts: 6
Joined: Wed Dec 10, 2008 9:39 pm

SQL Error after Installation

Post by JPamplin » Sun Dec 21, 2008 4:53 pm

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
Last edited by DavidIQ on Tue Dec 23, 2008 1:08 pm, edited 1 time in total.
Reason: Marked as resolved

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: SQL Error after Installation

Post by A_Jelly_Doughnut » Sun Dec 21, 2008 4:56 pm

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)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

JPamplin
Registered User
Posts: 6
Joined: Wed Dec 10, 2008 9:39 pm

Re: SQL Error after Installation

Post by JPamplin » Sun Dec 21, 2008 5:21 pm

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

JPamplin
Registered User
Posts: 6
Joined: Wed Dec 10, 2008 9:39 pm

Re: SQL Error after Installation

Post by JPamplin » Sun Dec 21, 2008 5:25 pm

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

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: SQL Error after Installation

Post by A_Jelly_Doughnut » Sun Dec 21, 2008 5:29 pm

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.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: SQL Error after Installation

Post by RMcGirr83 » Sun Dec 21, 2008 5:30 pm

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?
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

JPamplin
Registered User
Posts: 6
Joined: Wed Dec 10, 2008 9:39 pm

Re: SQL Error after Installation

Post by JPamplin » Sun Dec 21, 2008 5:57 pm

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

kraski
Registered User
Posts: 1
Joined: Tue Dec 30, 2008 11:20 pm

Re: SQL Error after Installation

Post by kraski » Tue Dec 30, 2008 11:31 pm

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()

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 17031
Joined: Thu Jan 06, 2005 1:30 pm
Location: Fishkill, NY
Name: David Colón
Contact:

Re: SQL Error after Installation

Post by DavidIQ » Wed Dec 31, 2008 4:19 am

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_).
Apply to become a Jr. Extension Validator
My extensions | In need of phpBB services? | Was I helpful today?
No unsolicited PMs unless you're planning on asking for paid help.

Locked

Return to “[3.0.x] AutoMOD”