| Autor | itsat |
| Datum | 22.02.2008 16:21 |
| Beiträge: |  Hallo,
versuche nun seit ein paar Stunden opn zumindest in einer Testinstallation zum laufen zu bringen, hänge aber immer an der gleichen Stelle fest, bei Schritt 7: Erstellen der Tabellen / Indexe usw. Erstmal die Umgebung: Windows 2000 Server Apache 2.2.4 PHP 5.2.3 MySQL 5.0.45 opn 2.4.11 Der Fehler: **** mysql error: [1101: BLOB/TEXT column 'description' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_protector_log (lid INT (11) DEFAULT '0' NOT NULL, uid INT (11) DEFAULT '0' NOT NULL, ip VARCHAR (16) DEFAULT '' NOT NULL, ptype VARCHAR (255) DEFAULT '' NOT NULL, agent VARCHAR (255) DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, extra TEXT DEFAULT '' NOT NULL, wtime NUMERIC (15,5) DEFAULT '0' NOT NULL, PRIMARY KEY (lid)) ") mysql error: [1101: BLOB/TEXT column 'data' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_mem (id VARCHAR (240) DEFAULT '' NOT NULL, data TEXT DEFAULT '' NOT NULL, wtime NUMERIC (15,5) DEFAULT '0' NOT NULL, PRIMARY KEY (id)) ") mysql error: [1101: BLOB/TEXT column 'options' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_exception_register (id INT (11) DEFAULT '0' NOT NULL, module VARCHAR (100) DEFAULT '' NOT NULL, exception_name VARCHAR (250) DEFAULT '' NOT NULL, exception_point VARCHAR (250) DEFAULT '' NOT NULL, exception_text VARCHAR (250) DEFAULT '' NOT NULL, function_name VARCHAR (250) DEFAULT '' NOT NULL, options BLOB DEFAULT '' NOT NULL, function_file VARCHAR (250) DEFAULT '' NOT NULL) ") mysql error: [1101: BLOB/TEXT column 'options' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_exception_uid (id INT (11) DEFAULT '0' NOT NULL, eid VARCHAR (250) DEFAULT '' NOT NULL, uid INT (11) DEFAULT '0' NOT NULL, options BLOB DEFAULT '' NOT NULL, wtime NUMERIC (15,5) DEFAULT '0' NOT NULL) ") mysql error: [1101: BLOB/TEXT column 'shared_class' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_class_register (id INT (11) DEFAULT '0' NOT NULL, module VARCHAR (100) DEFAULT '' NOT NULL, shared_class BLOB DEFAULT '' NOT NULL, shared_opn_class BLOB DEFAULT '' NOT NULL, options BLOB DEFAULT '' NOT NULL) ") mysql error: [1101: BLOB/TEXT column 'keywords' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_meta_site_tags (pagename VARCHAR (50) DEFAULT '' NOT NULL, keywords TEXT DEFAULT '' NOT NULL, description TEXT DEFAULT '' NOT NULL, title TEXT DEFAULT '' NOT NULL, PRIMARY KEY (pagename)) ") mysql error: [1101: BLOB/TEXT column 'settings' can't have a default value] in EXECUTE("CREATE TABLE opn_configs (modulename VARCHAR (100) DEFAULT '' NOT NULL, settings TEXT DEFAULT '' NOT NULL, psettings TEXT DEFAULT '' NOT NULL, PRIMARY KEY (modulename)) ") mysql error: [1101: BLOB/TEXT column 'settings' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_user_configs (modulename VARCHAR (100) DEFAULT '' NOT NULL, uid INT (11) DEFAULT '0' NOT NULL, settings TEXT DEFAULT '' NOT NULL, module_pos VARCHAR (100) DEFAULT '' NOT NULL) ") mysql error: [1101: BLOB/TEXT column 'sideboxes' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_plugins (plugin VARCHAR (100) DEFAULT '' NOT NULL, sideboxes BLOB DEFAULT '' NOT NULL, pluginflags VARCHAR (35) DEFAULT '00000X00000X00000X00000X00000X00000' NOT NULL, middleboxes BLOB DEFAULT '' NOT NULL, opnboxes BLOB DEFAULT '' NOT NULL) ") mysql error: [1101: BLOB/TEXT column 'helptext' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_onlinehilfe (hid INT (11) DEFAULT '0' NOT NULL, plugin VARCHAR (40) DEFAULT '' NOT NULL, module VARCHAR (40) DEFAULT '' NOT NULL, feldname VARCHAR (40) DEFAULT '' NOT NULL, feldtype VARCHAR (40) DEFAULT '' NOT NULL, helptext TEXT DEFAULT '' NOT NULL, writtenbyuid INT (11) DEFAULT '1' NOT NULL, checkedbyuid INT (11) DEFAULT '1' NOT NULL, lang VARCHAR (40) DEFAULT '' NOT NULL, res1 INT (11) DEFAULT '1' NOT NULL, PRIMARY KEY (hid)) ") mysql error: [1101: BLOB/TEXT column 'user_xt_option' can't have a default value] in EXECUTE("CREATE TABLE opn_users (uid INT (11) DEFAULT '0' NOT NULL, uname VARCHAR (60) DEFAULT '' NOT NULL, email VARCHAR (60) DEFAULT '' NOT NULL, user_regdate NUMERIC (15,5) DEFAULT '0' NOT NULL, user_xt_option TEXT DEFAULT '' NOT NULL, user_debug INT (3) DEFAULT '0' NOT NULL, pass VARCHAR (40) DEFAULT '' NOT NULL, storynum INT (4) DEFAULT '10' NOT NULL, umode VARCHAR (10) DEFAULT '' NOT NULL, uorder INT (1) DEFAULT '0' NOT NULL, thold INT (1) DEFAULT '0' NOT NULL, noscore INT (1) DEFAULT '0' NOT NULL, ublockon INT (1) DEFAULT '0' NOT NULL, ublock TEXT DEFAULT '' NOT NULL, theme VARCHAR (255) DEFAULT '' NOT NULL, commentmax INT (11) DEFAULT '4096' NOT NULL, counter INT (11) DEFAULT '0' NOT NULL, rights INT (11) DEFAULT '0' NOT NULL, user_group INT (11) DEFAULT '1' NOT NULL, PRIMARY KEY (uid)) ") mysql error: [1101: BLOB/TEXT column 'user_xt_option' can't have a default value] in EXECUTE("CREATE TABLE opn_opn_user_dat (user_uid INT (11) DEFAULT '0' NOT NULL, user_name VARCHAR (60) DEFAULT '' NOT NULL, user_email VARCHAR (60) DEFAULT '' NOT NULL, user_password VARCHAR (60) DEFAULT '' NOT NULL, user_status INT (11) DEFAULT '1' NOT NULL, user_rgroup INT (11) DEFAULT '1' NOT NULL, user_xt_option TEXT DEFAULT '' NOT NULL, PRIMARY KEY (user_uid)) ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("ALTER TABLE opn_opn_plugins ADD INDEX idxopn_pluginsidx1 (plugin)") mysql error: [1146: Table 'opn.opn_opn_onlinehilfe' doesn't exist] in EXECUTE("ALTER TABLE opn_opn_onlinehilfe ADD INDEX idxopn_onlinehilfeidx1 (lang,plugin,module,feldname,feldtype)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx1 (uname)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx2 (email)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx3 (counter)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx4 (uid)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx5 (uid,uname)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx6 (email,uid)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx7 (uname,pass)") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("ALTER TABLE opn_users ADD INDEX idxusersidx8 (user_group)") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/masterinterfaceaccess', 's:0:"";', '00000X00000X00000X00002X08456X00017', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/modulinfos', 's:0:"";', '00000X00000X00000X00002X00264X00017', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/metatags', 's:0:"";', '00000X00000X00000X00002X08456X00017', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/openphpnuke', 'a:4:{i:0;s:8:"bookmark";i:1;s:13:"devautoupdate";i:2;s:8:"opnguide";i:3;s:8:"vardebug";}', '00000X00000X00000X00002X00424X08281', 'a:4:{i:0;s:10:"opnversion";i:1;s:9:"translate";i:2;s:14:"languagechoose";i:3;s:10:"opncssview";}', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/errorlog', 's:0:"";', '00000X00000X00000X00002X08456X00281', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/diagnostic', 's:0:"";', '00000X00000X00000X00000X00264X00273', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/plugins', 's:0:"";', '00000X00000X00000X00002X00264X00017', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/sidebox', 's:0:"";', '00000X00000X00000X00002X08456X00017', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/modultheme', 's:0:"";', '00000X00000X00000X00002X08456X00017', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/middlebox', 's:0:"";', '00000X00000X00000X00002X08456X00017', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/debuging', 's:0:"";', '00000X00000X00000X00000X00264X00000', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/updatemanager', 's:0:"";', '00000X00000X00000X00002X00392X00025', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/useradmin', 's:0:"";', '00000X00000X00000X00000X00280X32793', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/honeypot', 's:0:"";', '00000X00000X00000X00000X08456X00281', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('admin/user_group', 's:0:"";', '00000X00000X00000X00002X00297X00017', 'a:1:{i:0;s:9:"usergroup";}', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('system/onlinehilfe', 's:0:"";', '00000X00000X00000X00018X12553X00009', 's:0:"";', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('system/admin', 'a:1:{i:0;s:9:"adminmenu";}', '00000X00000X00000X00003X00299X05440', 'a:2:{i:0;s:9:"adminmenu";i:1;s:7:"waiting";}', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('system/user', 'a:4:{i:0;s:4:"menu";i:1;s:15:"moduleadminmenu";i:2;s:8:"userinfo";i:3;s:8:"settheme";}', '00000X00000X00000X00018X12589X24946', 'a:7:{i:0;s:9:"menuindex";i:1;s:4:"user";i:2;s:8:"loginbox";i:3;s:6:"online";i:4;s:8:"lastuser";i:5;s:10:"userstatus";i:6;s:9:"usertasks";}', '') ") mysql error: [1146: Table 'opn.opn_opn_plugins' doesn't exist] in EXECUTE("INSERT INTO opn_opn_plugins VALUES ('system/theme_group', 's:0:"";', '00000X00000X00000X04098X08489X01809', 'a:1:{i:0;s:11:"theme_group";}', '') ") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("INSERT INTO opn_users VALUES (1, 'anonymous', '', 0, 's:0:"";', 0, '71dce10b53f4c2c3fddb9d82a3cb4e2f', 10, '', 0, 0, 0, 0, '', '', 4096, 0, 0, 0) ") mysql error: [1146: Table 'opn.opn_users' doesn't exist] in EXECUTE("INSERT INTO opn_users VALUES (2, 'opn', 'info@teppernet.de', 2454519.52223, 's:0:"";', 0, 'opn', 10, '', 0, 0, 0, 0, '', '', 4096, 0, 0, 10) ") mysql error: [1146: Table 'opn.opn_configs' doesn't exist] in EXECUTE("INSERT INTO opn_configs VALUES ('admin/openphpnuke', 'a:144:{s:8:"sitename";s:11:"openPHPnuke";s:7:"opn_url";s:26:"http://opn.portalserverdev";s:9:"site_logo";s:0:"";s:9:"startdate";s:17:"February 22, 2008";s:9:"adminmail";s:17:"info@teppernet.de";s:3:"top";s:2:"10";s:13:"Default_Theme";s:11:"opn_default";s:9:"encodeurl";s:1:"1";s:18:"opn_mysql_pconnect";s:1:"0";s:13:"sessionexpire";s:5:"48000";s:19:"sessionexpire_bonus";s:6:"312000";s:28:"opn_display_fetching_request";s:1:"1";s:18:"opn_activate_email";s:1:"0";s:24:"opn_activate_email_debug";s:1:"0";s:8:"language";s:6:"german";s:20:"opn_charset_encoding";s:0:"";s:6:"locale";s:5:"de_DE";s:16:"opn_set_timezone";s:1:"0";s:12:"opn_timezone";s:0:"";s:21:"opn_host_use_safemode";s:1:"1";s:20:"opn_uname_test_level";s:1:"0";s:7:"minpass";s:1:"5";s:16:"opn_activatetype";s:1:"0";s:19:"opn_new_user_notify";s:1:"0";s:9:"show_user";s:2:"20";s:16:"opn_anonymous_id";s:1:"1";s:16:"opn_deleted_user";s:1:"1";s:18:"opn_webmaster_name";s:0:"";s:17:"opn_contact_email";s:0:"";s:5:"foot1";s:0:"";s:5:"foot2";s:168:"All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest ® 2007 by me ";s:5:"foot3";s:6:" ";s:5:"foot4";s:247:"This web site was made with openPHPnuke, a great web portal system written in PHP. openPHPnuke is Free Software released under the GNU/GPL license.";s:12:"admingraphic";s:1:"1";s:7:"uimages";s:6:"german";s:18:"opn_db_index_right";s:1:"1";s:13:"advancedstats";s:1:"1";s:13:"AllowableHTML";a:37:{s:1:"p";s:1:"2";s:1:"b";s:1:"1";s:1:"i";s:1:"1";s:1:"a";s:1:"2";s:3:"img";s:1:"2";s:2:"em";s:1:"1";s:2:"br";s:1:"1";s:6:"strong";s:1:"1";s:10:"blockquote";s:1:"1";s:2:"tt";s:1:"1";s:2:"li";s:1:"1";s:2:"ol";s:1:"1";s:2:"ul";s:1:"1";s:2:"hr";s:1:"1";s:7:"marquee";s:1:"1";s:1:"u";s:1:"1";s:1:"s";s:1:"1";s:3:"big";s:1:"1";s:5:"small";s:1:"1";s:3:"sub";s:1:"1";s:3:"sup";s:1:"1";s:3:"pre";s:1:"1";s:3:"ins";s:1:"1";s:3:"del";s:1:"1";s:4:"span";s:1:"2";s:3:"div";s:1:"2";s:1:"q";s:1:"1";s:2:"h1";s:1:"1";s:2:"h2";s:1:"1";s:2:"h3";s:1:"1";s:2:"h4";s:1:"1";s:2:"h5";s:1:"1";s:2:"h6";s:1:"1";s:4:"code";s:1:"1";s:2:"dd";s:1:"1";s:2:"dl";s:1:"1";s:2:"dt";s:1:"1";}s:10:"CensorList";a:14:{i:0;s:4:"fuck";i:1;s:4:"cunt";i:2;s:6:"fucker";i:3;s:7:"fucking";i:4;s:5:"pussy";i:5;s:4:"cock";i:6;s:4:"c0ck";i:7;s:3:"cum";i:8;s:4:"twat";i:9;s:4:"clit";i:10;s:5:"bitch";i:11;s:3:"fuk";i:12;s:6:"fuking";i:13;s:12:"motherfucker";}s:15:"ReplacementList";a:14:{i:0;s:8:"**beep**";i:1;s:8:"**beep**";i:2;s:8:"**beep**";i:3;s:8:"**beep**";i:4;s:8:"**beep**";i:5;s:8:"**beep**";i:6;s:8:"**beep**";i:7;s:8:"**beep**";i:8;s:8:"**beep**";i:9;s:8:"**beep**";i:10;s:8:"**beep**";i:11;s:8:"**beep**";i:12;s:8:"**beep**";i:13;s:8:"**beep**";}s:10:"CensorMode";s:1:"0";s:6:"slogan";s:24:"OpenPHPNuke - Das Portal";s:26:"display_complete_adminmenu";s:1:"0";s:13:"show_loadtime";s:1:"1";s:18:"opn_anonymous_name";s:9:"anonymous";s:17:"Form_autocomplete";s:1:"0";s:22:"opn_showadminmodernart";s:1:"0";s:15:"update_useProxy";s:1:"0";s:14:"update_ProxyIP";s:9:"127.0.0.1";s:16:"update_ProxyPort";s:4:"8080";s:19:"OPN_masterinterface";s:1:"0";s:22:"opn_uname_allow_spaces";s:1:"0";s:16:"opn_use_sendmail";s:1:"0";s:20:"opn_use_coredevdebug";s:1:"0";s:18:"opn_use_checkemail";s:1:"0";s:7:"opnmail";s:9:"opnpopper";s:11:"opnmailpass";s:12:"pleasechange";s:7:"opnpass";s:12:"pleasechange";s:21:"opn_upload_size_limit";s:5:"30000";s:16:"opn_server_chmod";s:4:"0666";s:20:"opn_server_dir_chmod";s:4:"0777";s:19:"opn_gfx_imagecreate";s:11:"imagecreate";s:24:"opn_gfx_imagecopyresized";s:16:"imagecopyresized";s:23:"opn_gfx_defaultlistrows";s:2:"20";s:12:"opn_bot_user";s:1:"1";s:12:"opn_ServerIP";s:0:"";s:13:"opn_dirmanage";s:1:"0";s:15:"opn_ftpusername";s:0:"";s:15:"opn_ftppassword";s:0:"";s:11:"opn_ftphost";s:9:"localhost";s:11:"opn_ftpport";s:2:"21";s:10:"opn_ftpdir";s:0:"";s:12:"opn_ftpchmod";s:4:"0666";s:11:"opn_ftppasv";s:1:"1";s:15:"opn_db_safe_use";s:1:"0";s:15:"opn_db_lock_use";s:1:"0";s:16:"opn_MailServerIP";s:0:"";s:20:"Form_HTML_BUTTONWORD";s:1:"0";s:21:"Form_HTML_BUTTONEXCEL";s:1:"0";s:27:"opn_new_user_actasblacklist";s:1:"1";s:19:"opn_list_domainname";s:0:"";s:15:"opn_expert_mode";s:1:"0";s:19:"opn_startthemegroup";s:1:"0";s:21:"opn_expert_autorepair";s:1:"0";s:20:"opn_safetyadjustment";s:1:"0";s:12:"block_filter";s:1:"0";s:15:"opn_time_prefix";s:10:"1203690623";s:26:"opn_email_charset_encoding";s:10:"iso-8859-1";s:26:"opn_email_subject_encoding";s:0:"";s:23:"opn_email_body_encoding";s:6:"base64";s:25:"opn_default_accessibility";s:1:"0";s:22:"opn_meta_file_icon_set";s:0:"";s:13:"CensorReplace";s:1:"*";s:21:"opn_filter_spam_score";s:1:"0";s:18:"opn_use_perl_mkdir";s:1:"0";s:21:"opn_cookie_domainname";s:1:"0";s:26:"opn_emailgeneratemessageid";s:1:"0";s:17:"opn_emailpriority";s:1:"3";s:25:"safety_filtersetting_list";a:3:{i:0;s:6:"SCRIPT";i:1;s:5:"FRAME";i:2;s:6:"OBJECT";}s:20:"safety_filtersetting";s:1:"2";s:16:"opn_checkdocroot";s:1:"0";s:19:"safe_opn_bot_ignore";s:1:"0";s:25:"opn_graphic_security_code";s:1:"0";s:13:"opn_supporter";s:1:"0";s:19:"opn_supporter_email";s:0:"";s:18:"opn_supporter_name";s:19:"Dear OPN Supporter,";s:22:"opn_supporter_customer";s:8:"OPN User";s:28:"opn_masterinterface_popcheck";s:1:"0";s:13:"opn_start_day";s:1:"1";s:18:"opn_php5_migration";s:1:"0";s:19:"opn_cryptadjustment";s:1:"2";s:24:"opn_pure_html_guidelines";s:1:"1";s:26:"opn_generateautomatictitle";s:1:"0";s:14:"opn-theme-logo";s:0:"";s:11:"dos_testing";s:1:"0";s:15:"dos_expire_time";s:1:"2";s:16:"dos_expire_total";s:1:"5";s:14:"send_email_via";s:4:"mail";s:13:"sendmail_path";s:18:"/usr/sbin/sendmail";s:13:"sendmail_args";s:5:"-t -i";s:9:"smtp_host";s:0:"";s:9:"smtp_port";s:2:"25";s:9:"smtp_auth";s:1:"1";s:13:"smtp_username";s:0:"";s:13:"smtp_password";s:0:"";s:22:"opn_all_email_to_admin";s:1:"0";s:11:"opn_ftpmode";s:1:"1";s:16:"opn_textarea_row";s:2:"30";s:16:"opn_textarea_col";s:3:"100";s:17:"language_use_mode";s:1:"0";s:19:"opn_admin_icon_path";s:0:"";s:19:"opn_admin_icon_type";s:3:"jpg";s:14:"opn_use_mcrypt";s:1:"0";s:10:"cmd_apache";s:27:"/etc/init.d/apache2 restart";s:7:"cmd_zip";s:12:"/usr/bin/zip";s:9:"cmd_unzip";s:18:"/usr/bin/unzip -oq";s:13:"path_to_vhost";s:0:"";s:17:"spool_id_of_vhost";s:0:"";s:9:"cmd_mysql";s:0:"";s:17:"spool_id_of_mysql";s:0:"";s:36:"opn_sys_cronjob_delete_session_files";s:1:"0";s:33:"opn_sys_cronjob_heartbeat_working";s:1:"0";s:33:"opn_sys_cronjob_transport_working";s:1:"0";s:30:"opn_sys_use_apache_mod_rewrite";s:1:"0";}', 'a:0:{}') ") **** Die Ursache: Ihr versucht den text-Spalten Defaultwerte zu verpassen, dies ist lt. MySQL-Doku nicht möglich / erlaubt, siehe MySQL-Doku. Die Frage: Könnt ihr das kurzfristig beheben? Würde gern opn ausprobieren, aber wenn schon die Testinstallation fehlschlägt hätte sich das System leider disqualifiziert... Liebe Grüße! |
so etwas hatten wir schon mal und es gibt dazu auch einen thread.
Ich habe hier lokal unter Gentoo Linux MySQL 5.0.54 ohne Probleme mit OPN am laufen. Bei Gentoo gibt es auch z.B. die MySQL 5.0.45 gar nicht. Die sind direkt von der 5.044.auf die 5.0.54 gesprungen.
