ROZWIĄZANY: Problem z instalacją

10 Kwietnia 2011

Witam!

Posiadam problem z instalacją. Kiedyś miałem zainstalowaną galerie.

Podczas instalacji na samym początku pojawia sie błąd.

mySQL query error: SELECT * FROM ibf_gallery_categories

SQL error: Table 'csnspl_forum.ibf_gallery_categories' doesn't exist
SQL error code: 1146
Date: Sunday 10th April 2011 01:53:56 PM


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sun, 10 Apr 2011 13:53:56 +0000
Error: 1146 - Table 'csnspl_forum.ibf_gallery_categories' doesn't exist
IP Address: 86.63.146.112 - /admin/upgrade/index.php?app=upgrade&section=upgrade&do=sql
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM ibf_gallery_categories
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/gallery/setup/versions/upg_30000/version_upgrade.php| [version_upgrade].upgradeCategories                                     | 70                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/applications/upgrade/sections/upgrade.php                      | [version_upgrade].doExecute                                                   | 403               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/applications/upgrade/sections/upgrade.php                      | [upgrade_upgrade].install_appclass                                            | 337               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/applications/upgrade/sections/upgrade.php                      | [upgrade_upgrade].install_sql                                                 | 143               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/sources/base/ipsController_setup.php                           | [upgrade_upgrade].doExecute                                                   | 256               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Edytowane 10 Kwietnia 2011 przez XQS

**Jakub** · 10 Kwietnia 2011

Piszesz, że instalujesz, a w logach widać, że robisz upgrade. To jak w końcu z tym jest?

PS Powinno być: Mam problem z instalacją.

10 Kwietnia 2011

Kiedyś miałem zainstalowaną IP.Galery i odinstalowałem. Widocznie musiało coś zostać po niej.

**Jakub** · 10 Kwietnia 2011

Masz to na liście Nie zainstalowane aplikacje?

10 Kwietnia 2011

Nie mam, kiedy wchodze w Aplikacje i moduły mam do IP.Galery na liscie Nie zainstalowane aplikacje. Kilkam instalacje i przenosi mnie do upgrade.

**Jakub** · 10 Kwietnia 2011

Wykonaj takie zapytanie:

DELETE FROM ibf_upgrade_history WHERE upgrade_app='gallery';

i sprawdź czy pomogło.

10 Kwietnia 2011

Dalej wykrywa jako upgrade. I ten sam bład.

**Jakub** · 11 Kwietnia 2011

Masz prefiks tabel ibf_ czy jakiś inny? Jeśli inny to podmień w tym zapytaniu co Ci podałem.

24 Kwietnia 2011

Mam prefix ibf_ w tabeli. Tylko że instalacji gdzies zapisane jest ze niby mam tabele ibf_gallery_categories a takiej nie mam.

Moze jak bym ja recznie utworzył to by dało rade, ale nie wiem jak ma wygladać.

DawPi · 24 Kwietnia 2011

Łap:

CREATE TABLE IF NOT EXISTS `ibf_gallery_categories` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `last_pic_name` varchar(255) default NULL,
 `parent` int(10) unsigned NOT NULL default '0',
 `name` varchar(60) NOT NULL default '',
 `description` text,
 `c_order` int(10) unsigned NOT NULL default '0',
 `images` bigint(10) unsigned NOT NULL default '0',
 `comments` bigint(10) unsigned NOT NULL default '0',
 `perms_thumbs` varchar(120) NOT NULL default '',
 `perms_view` varchar(120) NOT NULL default '',
 `perms_images` varchar(120) NOT NULL default '',
 `perms_comments` varchar(120) NOT NULL default '',
 `perms_moderate` varchar(120) NOT NULL default '',
 `allow_ibfcode` tinyint(1) unsigned NOT NULL default '1',
 `allow_html` tinyint(1) unsigned NOT NULL default '0',
 `password` varchar(60) NOT NULL default '',
 `approve_images` tinyint(1) unsigned NOT NULL default '0',
 `imgs_per_col` int(5) unsigned NOT NULL default '4',
 `imgs_per_row` int(5) unsigned NOT NULL default '5',
 `watermark_images` tinyint(1) unsigned NOT NULL default '0',
 `thumbnail` tinyint(1) unsigned NOT NULL default '1',
 `allow_comments` tinyint(1) unsigned NOT NULL default '1',
 `approve_comments` tinyint(1) unsigned NOT NULL default '0',
 `inc_post_count` tinyint(1) unsigned NOT NULL default '1',
 `status` tinyint(1) unsigned NOT NULL default '1',
 `last_pic_id` int(10) unsigned NOT NULL default '0',
 `def_view` varchar(30) default 'idate:DESC:*',
 `rate` tinyint(1) unsigned NOT NULL default '1',
 `allow_movies` tinyint(1) unsigned NOT NULL default '0',
 `allow_images` tinyint(1) unsigned NOT NULL default '1',
 `category_only` tinyint(1) unsigned default '0',
 `album_mode` tinyint(1) unsigned NOT NULL default '0',
 `last_member_id` mediumint(8) unsigned default NULL,
 `mod_images` int(10) unsigned NOT NULL default '0',
 `mod_comments` int(10) NOT NULL default '0',
 `cat_rule_method` tinyint(1) unsigned NOT NULL default '0',
 `cat_rule_title` varchar(120) NOT NULL default '',
 `cat_rule_text` text,
 `mem_gallery` text,
 `last_pic_date` varchar(13) NOT NULL default '0',
 `name_seo` varchar(255) NOT NULL,
 `cover_img_id` bigint(10) NOT NULL,
 `images_per_page` smallint(4) NOT NULL default '25',
 PRIMARY KEY  (`id`),
 KEY `parent` (`parent`)
) ENGINE=MyISAM;

25 Kwietnia 2011

Dzieki, poszło

Ale w dalszej czesci instalacji jest bład.

Step 1/14

This Module: 4.0.0 Beta 1

(Gallery)

Error: ALTER TABLE ibf_gallery_images ADD image_media_data TEXT;

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images CHANGE album_id img_album_id INT(10) UNSIGNED NOT NULL DEFAULT 0;

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images CHANGE directory directory VARCHAR(255) NOT NULL DEFAULT '';

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_data TEXT NOT NULL;

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_privacy INT(1) NOT NULL DEFAULT 0;

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_parent_permission VARCHAR(255) NOT NULL DEFAULT '';

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_feature_flag INT(1) NOT NULL DEFAULT '0';

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_gps_raw TEXT;

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_gps_lat VARCHAR(255);

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_gps_lon VARCHAR(255);

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_gps_show INT(1) NOT NULL DEFAULT '0';

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD image_loc_short TEXT;

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD KEY im_select (approved, image_privacy, member_id, idate );

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD KEY gb_select (approved, image_parent_permission);

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD KEY image_feature_flag (image_feature_flag );

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD KEY idate (idate);

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD KEY lastcomment (lastcomment);

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD KEY cmt_lookup (image_privacy, member_id, image_parent_permission, img_album_id, approved, lastcomment);

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_gallery_images ADD KEY rnd_lookup (image_privacy, member_id, image_parent_permission, approved, idate );

Table 'csnspl_forum.ibf_gallery_images' doesn't exist

Error: ALTER TABLE ibf_groups CHANGE g_max_diskspace g_max_diskspace INT(10) DEFAULT '0';

Unknown column 'g_max_diskspace' in 'ibf_groups'

Error: ALTER TABLE ibf_groups CHANGE g_max_upload g_max_upload INT(10) DEFAULT '0';

Unknown column 'g_max_upload' in 'ibf_groups'

Error: ALTER TABLE ibf_groups CHANGE g_max_transfer g_max_transfer INT(10) DEFAULT '0';

Unknown column 'g_max_transfer' in 'ibf_groups'

Error: ALTER TABLE ibf_groups CHANGE g_max_views g_max_views INT(10) DEFAULT '0';

Unknown column 'g_max_views' in 'ibf_groups'

Error: ALTER TABLE ibf_groups CHANGE g_album_limit g_album_limit INT(10) DEFAULT '0';

Unknown column 'g_album_limit' in 'ibf_groups'

Error: ALTER TABLE ibf_groups CHANGE g_img_album_limit g_img_album_limit INT(10) DEFAULT '0';

Unknown column 'g_img_album_limit' in 'ibf_groups'

Error: ALTER TABLE ibf_groups CHANGE g_movie_size g_movie_size INT(10) DEFAULT '0';

Unknown column 'g_movie_size' in 'ibf_groups'

Error: UPDATE ibf_groups SET g_max_diskspace= -1 WHERE g_max_diskspace = 0;

Unknown column 'g_max_diskspace' in 'where clause'

Error: UPDATE ibf_groups SET g_max_upload= -1 WHERE g_max_upload = 0;

Unknown column 'g_max_upload' in 'where clause'

Error: UPDATE ibf_groups SET g_max_transfer= -1 WHERE g_max_transfer = 0;

Unknown column 'g_max_transfer' in 'where clause'

Error: UPDATE ibf_groups SET g_max_views= -1 WHERE g_max_views = 0;

Unknown column 'g_max_views' in 'where clause'

Error: UPDATE ibf_groups SET g_album_limit= -1 WHERE g_album_limit = 0;

Unknown column 'g_album_limit' in 'where clause'

Error: UPDATE ibf_groups SET g_img_album_limit= -1 WHERE g_img_album_limit = 0;

Unknown column 'g_img_album_limit' in 'where clause'

Error: UPDATE ibf_groups SET g_movie_size= -1 WHERE g_movie_size = 0;

Unknown column 'g_movie_size' in 'where clause'

Error: ALTER TABLE ibf_gallery_ratings CHANGE img_id rating_foreign_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0;

Table 'csnspl_forum.ibf_gallery_ratings' doesn't exist

Error: ALTER TABLE ibf_gallery_ratings ADD rating_where VARCHAR(10) NOT NULL DEFAULT 'image';

Table 'csnspl_forum.ibf_gallery_ratings' doesn't exist

Error: ALTER TABLE ibf_gallery_ratings DROP KEY member_id;

Table 'csnspl_forum.ibf_gallery_ratings' doesn't exist

Error: ALTER TABLE ibf_gallery_ratings DROP KEY img_id;

Table 'csnspl_forum.ibf_gallery_ratings' doesn't exist

Error: ALTER TABLE ibf_gallery_ratings ADD KEY rating_find_me (member_id, rating_foreign_id, rating_where);

Table 'csnspl_forum.ibf_gallery_ratings' doesn't exist

I klikam, przedz dalej. I wywala blad taki po ktorym nie da się kontynować:

mySQL query error: INSERT INTO `ibf_gallery_albums_main`
					(album_id, album_parent_id, album_owner_id, album_name, album_name_seo, album_description, album_is_public,
					 album_is_global, album_is_profile, album_count_imgs, album_count_comments, album_count_imgs_hidden,
					 album_count_comments_hidden, album_cover_img_id, album_last_img_id, album_last_img_date, album_sort_options,
					 album_allow_comments, album_cache, album_node_level, album_node_left, album_node_right, album_g_approve_img, album_g_approve_com,
					 album_g_bitwise, album_g_rules, album_g_password, album_g_container_only, album_g_perms_thumbs, album_g_perms_view,
					 album_g_perms_images, album_g_perms_comments, album_g_perms_moderate )

					( SELECT a.id, a.parent, a.member_id, a.name, a.name_seo, a.description,( CASE WHEN a.friend_only THEN 2 WHEN a.public_album THEN 1 ELSE 0 END ),
					0, a.profile_album, a.images, a.comments, a.mod_images,
					a.mod_comments, 0, 0, 0, '',
					1, CONCAT( 'cat-', a.category_id ), 0, 0, 0, 0, 0,
					0, '', '', 0, '*', '*',
					'*', '*', '' FROM `ibf_gallery_albums` a)

SQL error: Table 'csnspl_forum.ibf_gallery_albums' doesn't exist
SQL error code: 1146
Date: Monday 25th April 2011 02:56:57 PM


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 25 Apr 2011 14:56:57 +0000
Error: 1146 - Table 'csnspl_forum.ibf_gallery_albums' doesn't exist
IP Address: 62.244.129.93 - /admin/upgrade/index.php?app=upgrade&section=upgrade&do=appclass
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: INSERT INTO `ibf_gallery_albums_main`
					(album_id, album_parent_id, album_owner_id, album_name, album_name_seo, album_description, album_is_public,
					 album_is_global, album_is_profile, album_count_imgs, album_count_comments, album_count_imgs_hidden,
					 album_count_comments_hidden, album_cover_img_id, album_last_img_id, album_last_img_date, album_sort_options,
					 album_allow_comments, album_cache, album_node_level, album_node_left, album_node_right, album_g_approve_img, album_g_approve_com,
					 album_g_bitwise, album_g_rules, album_g_password, album_g_container_only, album_g_perms_thumbs, album_g_perms_view,
					 album_g_perms_images, album_g_perms_comments, album_g_perms_moderate )

					( SELECT a.id, a.parent, a.member_id, a.name, a.name_seo, a.description,( CASE WHEN a.friend_only THEN 2 WHEN a.public_album THEN 1 ELSE 0 END ),
					0, a.profile_album, a.images, a.comments, a.mod_images,
					a.mod_comments, 0, 0, 0, '',
					1, CONCAT( 'cat-', a.category_id ), 0, 0, 0, 0, 0,
					0, '', '', 0, '*', '*',
					'*', '*', '' FROM `ibf_gallery_albums` a)
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/gallery/setup/versions/upg_40000/version_upgrade.php| [version_upgrade].convertAlbums                                               | 109               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/applications/upgrade/sections/upgrade.php                      | [version_upgrade].doExecute                                                   | 403               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/applications/upgrade/sections/upgrade.php                      | [upgrade_upgrade].install_appclass                                            | 148               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/setup/sources/base/ipsController_setup.php                           | [upgrade_upgrade].doExecute                                                   | 256               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Żadne tabele z gallery u mnie w bazie nie istnieją.

Edytowane 25 Kwietnia 2011 przez XQS

25 Kwietnia 2011

Usunołem wpisy recznie z bazy z tabel: ibf_core_applications i ibf_upgrade_history i zainstalowałem

rozwiązany

**Jakub** · 25 Kwietnia 2011

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.

Zaloguj się

ROZWIĄZANY: Problem z instalacją

Rekomendowane odpowiedzi

Gość XQS

Jakub

Gość XQS

Jakub

Gość XQS

Jakub

Gość XQS

Jakub

Gość XQS

DawPi

Gość XQS

Gość XQS

Jakub

Ostatnio przeglądający 0 użytkowników

Pliki

Cała aktywność

Przeglądaj

Powiadomienie o plikach cookie