I think I need to add this to my SQL database

[Guru Imakuni]

Everything was going good until I got an error message on the last step saying that the following couldn't be entered into the database because "guildalliance.phpbb_easymod" didn't exist. I tried running the SQL as a query but that didn't work (I'm a MySQL newbie). Then I tried creating the string manually but I couldn't enter the values right I guess, there was no value value and "text" didn't work.

Please tell me how I can enter the following SQL into my database:

Code: Select all

INSERT INTO phpbb_easymod ( mod_title, mod_file, mod_version, mod_author_handle, mod_author_email, mod_author_name, mod_author_url, mod_description, mod_process_date, mod_phpBB_version, mod_processed_themes, mod_processed_langs, mod_files_edited, mod_tables_added, mod_tables_altered, mod_rows_inserted) VALUES ( 'EasyMOD', 'easymod/easymod_install.php', '0.1.13', 'Nuttzy', '[email protected]', 'n/a', 'http://www.blizzhackers.com', 'EasyMOD automatically perfoms in seconds which previously required the tedious task of manually editing files.', 1104636064, '2.0.11', 'subSilver', 'english', 0, 1, 0, 1)

[wtfdit]

i get exactly the same error.

* Error :: Table 'ozgeek_net_-_old.phpbb_easymod' doesn't exist
SQL :: INSERT INTO phpbb_easymod ( mod_title, mod_file, mod_version, mod_author_handle, mod_author_email, mod_author_name, mod_author_url, mod_description, mod_process_date, mod_phpBB_version, mod_processed_themes, mod_processed_langs, mod_files_edited, mod_tables_added, mod_tables_altered, mod_rows_inserted) VALUES ( 'EasyMOD', 'easymod/easymod_install.php', '0.1.13', 'Nuttzy', '[email protected]', 'n/a', 'http://www.blizzhackers.com', 'EasyMOD automatically perfoms in seconds which previously required the tedious task of manually editing files.', 1105262468, '2.0.11', 'subSilver; bluetabs', 'english', 0, 1, 0, 1)

SQL Error : 1146 Table 'ozgeek_net_-_old.phpbb_easymod' doesn't exist

[olger901]

First you need to create the EasyMOD table, then insert the data into it.
This can be done really easy using phpMyAdmin. Login to it, select your phphBB 2 database, the right window will change. In the right window click on the SQL Tab and copy paste the Create Table and Insert Into code in there and press go

[wtfdit]

that is what i thought, for some reason i assumed the install of easymod using the install.php file did this automatically.

[olger901]

It does for some installations while it doesn't for other, remember that this is beta software and contains bugs.

[raaabo]

Umm Ok I don't know jack about my sql, and I had the same problem. I kinda stumbled across a solution:


the first error I got was:

Result :: Some queries failed, the statements and errors are listing below

Error :: Invalid default value for 'mod_id'
SQL :: CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL DEFAULT '0'
auto_increment, mod_title varchar(50) NULL DEFAULT '', mod_file varchar(255) NULL DEFAULT '', mod_version varchar(15) NULL DEFAULT '', mod_author_handle varchar(25) NULL DEFAULT '', mod_author_email varchar(100) NULL DEFAULT '', mod_author_name varchar(100) NULL DEFAULT '', mod_author_url varchar(100) NULL DEFAULT '', mod_description text NULL DEFAULT '', mod_process_date int(11) NULL DEFAULT '0', mod_phpBB_version varchar(15) NULL DEFAULT '', mod_processed_themes varchar(200) NULL DEFAULT '', mod_processed_langs varchar(200) NULL DEFAULT '', mod_files_edited mediumint(8) NULL DEFAULT '0', mod_tables_added mediumint(8) NULL DEFAULT '0', mod_tables_altered mediumint(8) NULL DEFAULT '0', mod_rows_inserted mediumint(8) NULL DEFAULT '0', PRIMARY KEY (mod_id))

This is probably nothing to worry about, install will continue. Should this fail to complete you may need to seek help at our development board.

The second was:

Error :: Table 'raaabo.phpbb_easymod' doesn't exist
SQL :: INSERT INTO phpbb_easymod ( mod_title, mod_file, mod_version, mod_author_handle, mod_author_email, mod_author_name, mod_author_url, mod_description, mod_process_date, mod_phpBB_version, mod_processed_themes, mod_processed_langs, mod_files_edited, mod_tables_added, mod_tables_altered, mod_rows_inserted) VALUES ( 'EasyMOD', 'easymod/easymod_install.php', '0.1.13', 'Nuttzy', '[email protected]', 'n/a', 'http://www.blizzhackers.com', 'EasyMOD automatically perfoms in seconds which previously required the tedious task of manually editing files.', 1107083321, '2.0.11', 'subSilver', 'english', 0, 1, 0, 1)

When I tried to manually add SQL code to create the table I got the first error again. SQL said there was an error in the mod_id default field, so I just deleted auto_increment and ran the SQL command again. Worked this time. Then I ran the second (INSERT INTO) SQL command and that worked too... in case you guys wanna try my solution here's the code:

First enter this CREATE TABLE SQL command in your phpMyAdmin:

Code: Select all

CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL DEFAULT '0', mod_title varchar(50) NULL DEFAULT '', mod_file varchar(255) NULL DEFAULT '', mod_version varchar(15) NULL DEFAULT '', mod_author_handle varchar(25) NULL DEFAULT '', mod_author_email varchar(100) NULL DEFAULT '', mod_author_name varchar(100) NULL DEFAULT '', mod_author_url varchar(100) NULL DEFAULT '', mod_description text NULL DEFAULT '', mod_process_date int(11) NULL DEFAULT '0', mod_phpBB_version varchar(15) NULL DEFAULT '', mod_processed_themes varchar(200) NULL DEFAULT '', mod_processed_langs varchar(200) NULL DEFAULT '', mod_files_edited mediumint(8) NULL DEFAULT '0', mod_tables_added mediumint(8) NULL DEFAULT '0', mod_tables_altered mediumint(8) NULL DEFAULT '0', mod_rows_inserted mediumint(8) NULL DEFAULT '0', PRIMARY KEY (mod_id))

Then run this INSERT INTO SQL command:

Code: Select all

INSERT INTO phpbb_easymod ( mod_title, mod_file, mod_version, mod_author_handle, mod_author_email, mod_author_name, mod_author_url, mod_description, mod_process_date, mod_phpBB_version, mod_processed_themes, mod_processed_langs, mod_files_edited, mod_tables_added, mod_tables_altered, mod_rows_inserted) VALUES ( 'EasyMOD', 'easymod/easymod_install.php', '0.1.13', 'Nuttzy', '[email protected]', 'n/a', 'http&#58//www.blizzhackers.com', 'EasyMOD automatically perfoms in seconds which previously required the tedious task of manually editing files.', 1107083321, '2.0.11', 'subSilver', 'english', 0, 1, 0, 1)

Hope this helps someone, and doesn't screw things up more

Remember, this just worked for me, and since I'm an SQL n00b, I don't really recommend my own advice. Use it at your own peril

Cheers

Raaabo

[raaabo]

Please ignore the above post

How come I can't edit my posts?

removing auto_increment just screws up the phpbb_easymod database... it doesn't record any mod you install after that...

What I did then was edit the phpbb_easymod mod_id entry, removed the value of default and added auto_increment in Extra

(phpMyAdmin)

This seems to work...


I think the correct initial CREATE table string is:

Code: Select all

CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL auto_increment, mod_title varchar(50) NULL DEFAULT '', mod_file varchar(255) NULL DEFAULT '', mod_version varchar(15) NULL DEFAULT '', mod_author_handle varchar(25) NULL DEFAULT '', mod_author_email varchar(100) NULL DEFAULT '', mod_author_name varchar(100) NULL DEFAULT '', mod_author_url varchar(100) NULL DEFAULT '', mod_description text NULL DEFAULT '', mod_process_date int(11) NULL DEFAULT '0', mod_phpBB_version varchar(15) NULL DEFAULT '', mod_processed_themes varchar(200) NULL DEFAULT '', mod_processed_langs varchar(200) NULL DEFAULT '', mod_files_edited mediumint(8) NULL DEFAULT '0', mod_tables_added mediumint(8) NULL DEFAULT '0', mod_tables_altered mediumint(8) NULL DEFAULT '0', mod_rows_inserted mediumint(8) NULL DEFAULT '0', PRIMARY KEY (mod_id))

Mods / admins if you can confirm, please delete this post and paste the code above into my first post. That might make me look like less of a dumbass and would be greatly appreciated

Thanks

Raaabo

[wildteen88]

If you get this error message:

Result :: Some queries failed, the statements and errors are listing below

Error :: Invalid default value for 'mod_id'
SQL :: CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL
DEFAULT '0'
auto_increment, mod_title varchar(50) NULL DEFAULT '', mod_file varchar(255) NULL DEFAULT '', mod_version varchar(15) NULL DEFAULT '', mod_author_handle varchar(25) NULL DEFAULT '', mod_author_email varchar(100) NULL DEFAULT '', mod_author_name varchar(100) NULL DEFAULT '', mod_author_url varchar(100) NULL DEFAULT '', mod_description text NULL DEFAULT '', mod_process_date int(11) NULL DEFAULT '0', mod_phpBB_version varchar(15) NULL DEFAULT '', mod_processed_themes varchar(200) NULL DEFAULT '', mod_processed_langs varchar(200) NULL DEFAULT '', mod_files_edited mediumint(8) NULL DEFAULT '0', mod_tables_added mediumint(8) NULL DEFAULT '0', mod_tables_altered mediumint(8) NULL DEFAULT '0', mod_rows_inserted mediumint(8) NULL DEFAULT '0', PRIMARY KEY (mod_id))

This is probably nothing to worry about, install will continue. Should this fail to complete you may need to seek help at our development board.

You need to remove the first default '0' part from the script and then it'll be okay.
NOTE: Its the bit highlighted in red

[DVD-Man]

Yes. remove the value.. since it's set to auto_increment it shouldn't have a default value.

[raaabo]

Yeah, i found out the hard way, oh well, now I officially look like a dumbass

I guess I can take consolation in the fact that i corrected myself before others did