Table 'phpb1.phpbb_easymod' doesn't exist

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
mokojin
Registered User
Posts: 3
Joined: Sun Feb 17, 2008 3:52 pm

Table 'phpb1.phpbb_easymod' doesn't exist

Post by mokojin » Sun Feb 17, 2008 3:57 pm

hi

i just install easymod with some warning, but i can "use" the mod, and now i'm trying to install a mod, but when i enter process, it redirect to a blank page, dunno if the problem is from easymod or the mod, either way, when i go history, i get this error:

Code: Select all

Could not obtain EasyMod information

DEBUG MODE

SQL Error : 1146 Table 'phpb1.phpbb_easymod' doesn't exist

SELECT * FROM phpbb_easymod ORDER BY mod_id DESC

Line : 1142
File : admin_easymod.php

Any ideas?

I'm using phpbb 2 and easymod beta (0.3.0)

Thanks

Realisty
Registered User
Posts: 107
Joined: Sat Jan 20, 2007 3:37 pm

Re: Table 'phpb1.phpbb_easymod' doesn't exist

Post by Realisty » Sun Feb 17, 2008 5:47 pm

That error shows that easymod was not installed correctly

mokojin
Registered User
Posts: 3
Joined: Sun Feb 17, 2008 3:52 pm

Re: Table 'phpb1.phpbb_easymod' doesn't exist

Post by mokojin » Sun Feb 17, 2008 8:09 pm

I know, as i say on my post, but what i want is to know how to resolv the problem

Realisty
Registered User
Posts: 107
Joined: Sat Jan 20, 2007 3:37 pm

Re: Table 'phpb1.phpbb_easymod' doesn't exist

Post by Realisty » Sun Feb 17, 2008 8:46 pm

If you know the error then you could work from there ....otherwise try installing easymod again and look what the error is .... that way it is easier to give advice

User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Table 'phpb1.phpbb_easymod' doesn't exist

Post by Lumpy Burgertushie » Sun Feb 17, 2008 9:17 pm

Table 'phpb1.phpbb_easymod' doesn't exist

that is the clue. it did not create the tables in the database.

try again.

robert

mokojin
Registered User
Posts: 3
Joined: Sun Feb 17, 2008 3:52 pm

Re: Table 'phpb1.phpbb_easymod' doesn't exist

Post by mokojin » Mon Feb 18, 2008 1:36 pm

Ok, i reinstall easymod to get the errors, that are the following:

Code: Select all

Adding EasyMOD tables to your database
Executing SQL:
CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL auto_increment, mod_title varchar(255) 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))

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

    * Error :: BLOB/TEXT column 'mod_description' can't have a default value
      SQL   :: CREATE TABLE phpbb_easymod ( mod_id mediumint(8) NOT NULL auto_increment, mod_title varchar(255) 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.

Code: Select all

Updating EasyMOD table data
Storing config table entries: Done

Executing 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.3.0', '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.', 1203341614, '2.0.22', 'subSilver; WoWMoonclaw01', 'albanian; arabic; asturian; azerbaijani; basque; belarusian; bosnian; bulgarian; catalan; chinese_simplified; chinese_traditional; dutch; english; estonian; farsi; finnish; french; german; hebrew; indonesian; italian; japanese; korean; kurdish; lithuanian; macedonian; mongolian; norwegian; norwegian_nynorsk; polish; portuguese_brazil; romanian; romanian_no_diacritics; russian; russian_tu; serbian; serbian_cyrillic; slovak; spanish; spanish_argentina; swedish; thai; turkish; uighur; vietnamese; welsh', 0, 1, 0, 1)

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

    * Error :: Table 'phpb1.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.3.0', '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.', 1203341614, '2.0.22', 'subSilver; WoWMoonclaw01', 'albanian; arabic; asturian; azerbaijani; basque; belarusian; bosnian; bulgarian; catalan; chinese_simplified; chinese_traditional; dutch; english; estonian; farsi; finnish; french; german; hebrew; indonesian; italian; japanese; korean; kurdish; lithuanian; macedonian; mongolian; norwegian; norwegian_nynorsk; polish; portuguese_brazil; romanian; romanian_no_diacritics; russian; russian_tu; serbian; serbian_cyrillic; slovak; spanish; spanish_argentina; swedish; thai; turkish; uighur; vietnamese; welsh', 0, 1, 0, 1)

User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Table 'phpb1.phpbb_easymod' doesn't exist

Post by Lumpy Burgertushie » Sat Feb 23, 2008 9:59 pm

it is still not creating the table it needs.

the error may have something to do with mysql versions or something

what type of database do you have and what version is it.

if you do not know, check in your hosting control panel and/or ask your host.

robert

Locked