I think I need to add this to my SQL database

Having problems installing EM? Let's fix that
Forum rules
DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Locked
Guru Imakuni
Registered User
Posts: 1
Joined: Sun Jan 02, 2005 3:38 am

I think I need to add this to my SQL database

Post by Guru Imakuni » Sun Jan 02, 2005 3:42 am

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', 'pktoolkit@blizzhackers.com', '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
Registered User
Posts: 4
Joined: Sun Jan 09, 2005 10:11 am

Re: I think I need to add this to my SQL database

Post by wtfdit » Sun Jan 09, 2005 10:13 am

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', 'pktoolkit@blizzhackers.com', '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

User avatar
olger901
Registered User
Posts: 536
Joined: Tue May 11, 2004 4:57 pm

Re: I think I need to add this to my SQL database

Post by olger901 » Sun Jan 09, 2005 11:32 am

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
Registered User
Posts: 4
Joined: Sun Jan 09, 2005 10:11 am

Re: I think I need to add this to my SQL database

Post by wtfdit » Sun Jan 09, 2005 9:03 pm

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

User avatar
olger901
Registered User
Posts: 536
Joined: Tue May 11, 2004 4:57 pm

Re: I think I need to add this to my SQL database

Post by olger901 » Mon Jan 10, 2005 11:58 am

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

raaabo
Registered User
Posts: 4
Joined: Thu Jan 27, 2005 6:14 am

Re: I think I need to add this to my SQL database

Post by raaabo » Sun Jan 30, 2005 11:42 am

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', 'pktoolkit@blizzhackers.com', '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', 'pktoolkit@blizzhackers.com', '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
Registered User
Posts: 4
Joined: Thu Jan 27, 2005 6:14 am

Re: I think I need to add this to my SQL database

Post by raaabo » Sun Jan 30, 2005 12:21 pm

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
Registered User
Posts: 115
Joined: Fri Jan 21, 2005 8:23 pm

Re: I think I need to add this to my SQL database

Post by wildteen88 » Sun Jan 30, 2005 4:04 pm

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
Registered User
Posts: 4
Joined: Sun Jan 30, 2005 7:42 pm

Re: I think I need to add this to my SQL database

Post by DVD-Man » Mon Jan 31, 2005 12:39 pm

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

raaabo
Registered User
Posts: 4
Joined: Thu Jan 27, 2005 6:14 am

Re: I think I need to add this to my SQL database

Post by raaabo » Wed Feb 02, 2005 10:30 am

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 :D

Locked