#1 2018-05-27 15:07:53

Max_Honig
Mitglied
2018-05-20
7

Plugin Community Fehler Mysql

Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'recursive enum('true','false') NOT NULL DEFAULT 'true',
  create_subcategories e' at line 8

CREATE TABLE IF NOT EXISTS sraj_community_permissions (
  id int(11) NOT NULL AUTO_INCREMENT,
  type varchar(255) NOT NULL,
  group_id smallint(5) unsigned DEFAULT NULL,
  user_id mediumint(8) unsigned DEFAULT NULL,
  category_id smallint(5) unsigned DEFAULT NULL,
  user_album enum('true','false') NOT NULL DEFAULT 'false',
  recursive enum('true','false') NOT NULL DEFAULT 'true',
  create_subcategories enum('true','false') NOT NULL DEFAULT 'false',
  moderated enum('true','false') NOT NULL DEFAULT 'true',
  nb_photos int DEFAULT NULL,
  storage int DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845



Warning:  [mysql error 1146] Table 'u235176455_nunev.sraj_community_permissions' doesn't exist
SHOW COLUMNS FROM `sraj_community_permissions` LIKE "nb_photos"; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845


Notice: Trying to get property of non-object in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 216


Warning:  [mysql error 1146] Table 'u235176455_nunev.sraj_community_permissions' doesn't exist
ALTER TABLE `sraj_community_permissions` ADD `nb_photos` INT DEFAULT NULL; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845



Warning:  [mysql error 1146] Table 'u235176455_nunev.sraj_community_permissions' doesn't exist
SHOW COLUMNS FROM `sraj_community_permissions` LIKE "storage"; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845


Notice: Trying to get property of non-object in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 216


Warning:  [mysql error 1146] Table 'u235176455_nunev.sraj_community_permissions' doesn't exist
ALTER TABLE `sraj_community_permissions` ADD `storage` INT DEFAULT NULL; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845



Warning:  [mysql error 1146] Table 'u235176455_nunev.sraj_community_permissions' doesn't exist
SHOW COLUMNS FROM `sraj_community_permissions` LIKE "user_album"; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845


Notice: Trying to get property of non-object in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 216


Warning:  [mysql error 1146] Table 'u235176455_nunev.sraj_community_permissions' doesn't exist
ALTER TABLE `sraj_community_permissions` ADD `user_album` enum('true','false') NOT NULL DEFAULT 'false' after `category_id`; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845



Warning:  [mysql error 1146] Table 'u235176455_nunev.sraj_community_permissions' doesn't exist
SHOW COLUMNS FROM `sraj_community_permissions` LIKE "user_id"; in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 845


Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php:226 Stack trace: #0 /home/u235176455/public_html/photobook/plugins/community/maintain.class.php(85): pwg_db_fetch_assoc(false) #1 /home/u235176455/public_html/photobook/plugins/community/maintain.class.php(124): community_maintain->install('2.9.b-beta', Array) #2 /home/u235176455/public_html/photobook/admin/include/plugins.class.php(192): community_maintain->activate('2.9.b-beta', Array) #3 /home/u235176455/public_html/photobook/admin/plugins_installed.php(73): plugins->perform_action('activate', 'community') #4 /home/u235176455/public_html/photobook/admin/plugins.php(46): include('/home/u23517645...') #5 /home/u235176455/public_html/photobook/admin.php(311): include('/home/u23517645...') #6 {main} thrown in /home/u235176455/public_html/photobook/include/dblayer/functions_mysqli.inc.php on line 226


Kann mir da Jemand helfen?

Offline

#2 2018-05-27 15:11:33

Max_Honig
Mitglied
2018-05-20
7

Re: Plugin Community Fehler Mysql

Ich habe die Tabellen und einträge selber erstellt, doch dann bekomme ich weitere Fehler+

Jemand ne Ahnung?

Offline

#3 2018-05-30 06:41:56

Max_Honig
Mitglied
2018-05-20
7

Re: Plugin Community Fehler Mysql

Hat keiner eine Idee? Das Problem ist plötzlich aufgetreten.

Zwei Tage vorher lief es problemlos!

Habe die Zeilen manuell zugefügt, klappt nicht. Ich kann ds Plugin dann installieren und im Admin alles einstellen. Doch kann ich dann die Hauptseite nicht mehr aufrufen.

Ich habe es auch mit vier verschiedenen PHP versionen ausprobiert,, leider auch erfolglos .

Hat jemand ne Ahnung ob es ein problem vom Script oder eher ein Problem vom Server ist?!

Beitrag geändert von Max_Honig (2018-05-30 06:44:33)

Offline

Brett Fußzeile

Unterstützt von FluxBB

github twitter newsletter Spenden Piwigo.org © 2002-2024 · Kontakt