1
Installation, Update & Configuration / Re: 4images 4.71 updaten auf 4.72 und installation auf neuer Maschine
« on: April 27, 2006, 07:33:48 AM »
Ja, OK, sorry hab mich verschrieben!!! War mit dem Gedanken bei einem anderem Programm.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
...
btw:
v@no, how do you make this nice Pictuge with stats in your signature ?
http://www.4homepages.de/forum/index.php?topic=6755.0
...c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits...
Has anyone tested this mod with 1.7.1?
CREATE TABLE fotos1_4images_ban_logs ( id mediumint(10) NOT NULL auto_increment, `date` int(11) NOT NULL default '0', ban_id mediumint(12) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM
CREATE TABLE fotos1_4images_ban_logs ( id mediumint(10) NOT NULL auto_increment, `date` int(11) NOT NULL default '0', ban_id mediumint(12) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id))Ich habe also "
CREATE TABLE fotos1_4images_ban (id mediumint(12) NOT NULL auto_increment, `type` tinyint(1) NOT NULL default '0', active tinyint(1) NOT NULL default '0', ip1_start tinyint(3) unsigned NOT NULL default '0', ip1_end tinyint(3) unsigned NOT NULL default '0', ip2_start tinyint(3) unsigned NOT NULL default '0', ip2_end tinyint(3) unsigned NOT NULL default '0', ip3_start tinyint(3) unsigned NOT NULL default '0', ip3_end tinyint(3) unsigned NOT NULL default '0', ip4_start tinyint(3) unsigned NOT NULL default '0', ip4_end tinyint(3) unsigned NOT NULL default '0', user_id mediumint(10) NOT NULL default '0', name varchar(255) NOT NULL default '', hostname tinytext NOT NULL, email tinytext NOT NULL, `date` int(11) NOT NULL default '0', expire int(11) NOT NULL default '0', message text NOT NULL, reason text NOT NULL, PRIMARY KEY (id), KEY active (active)) ENGINE=MyISAM
CREATE TABLE fotos1_4images_ban (id mediumint(12) NOT NULL auto_increment, `type` tinyint(1) NOT NULL default '0', active tinyint(1) NOT NULL default '0', ip1_start tinyint(3) unsigned NOT NULL default '0', ip1_end tinyint(3) unsigned NOT NULL default '0', ip2_start tinyint(3) unsigned NOT NULL default '0', ip2_end tinyint(3) unsigned NOT NULL default '0', ip3_start tinyint(3) unsigned NOT NULL default '0', ip3_end tinyint(3) unsigned NOT NULL default '0', ip4_start tinyint(3) unsigned NOT NULL default '0', ip4_end tinyint(3) unsigned NOT NULL default '0', user_id mediumint(10) NOT NULL default '0', name varchar(255) NOT NULL default '', hostname tinytext NOT NULL, email tinytext NOT NULL, `date` int(11) NOT NULL default '0', expire int(11) NOT NULL default '0', message text NOT NULL, reason text NOT NULL, PRIMARY KEY (id), KEY active (active))Ich habe also "
Hello. I´ve got this Error, when i do the ban_install.php:Code: [Select]DB Error: Bad SQL Query: CREATE TABLE 4images_ban (id mediumint(12) NOT NULL auto_increment, `type` tinyint(1) NOT NULL default '0', active tinyint(1) NOT NULL default '0', ip1_start tinyint(3) unsigned NOT NULL default '0', ip1_end tinyint(3) unsigned NOT NULL default '0', ip2_start tinyint(3) unsigned NOT NULL default '0', ip2_end tinyint(3) unsigned NOT NULL default '0', ip3_start tinyint(3) unsigned NOT NULL default '0', ip3_end tinyint(3) unsigned NOT NULL default '0', ip4_start tinyint(3) unsigned NOT NULL default '0', ip4_end tinyint(3) unsigned NOT NULL default '0', user_id mediumint(10) NOT NULL default '0', name varchar(255) NOT NULL default '', hostname tinytext NOT NULL, email tinytext NOT NULL, `date` int(11) NOT NULL default '0', expire int(11) NOT NULL default '0', message text NOT NULL, reason text NOT NULL, PRIMARY KEY (id), KEY active (active)) ENGINE=MyISAM
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1
DB Error: Bad SQL Query: CREATE TABLE 4images_ban_logs ( id mediumint(10) NOT NULL auto_increment, `date` int(11) NOT NULL default '0', ban_id mediumint(12) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1
1. Error
CREATE TABLE 4images_ban (id mediumint(12) NOT NULL auto_increment, `type` tinyint(1) NOT NULL default '0', active tinyint(1) NOT NULL default '0', ip1_start tinyint(3) unsigned NOT NULL default '0', ip1_end tinyint(3) unsigned NOT NULL default '0', ip2_start tinyint(3) unsigned NOT NULL default '0', ip2_end tinyint(3) unsigned NOT NULL default '0', ip3_start tinyint(3) unsigned NOT NULL default '0', ip3_end tinyint(3) unsigned NOT NULL default '0', ip4_start tinyint(3) unsigned NOT NULL default '0', ip4_end tinyint(3) unsigned NOT NULL default '0', user_id mediumint(10) NOT NULL default '0', name varchar(255) NOT NULL default '', hostname tinytext NOT NULL, email tinytext NOT NULL, `date` int(11) NOT NULL default '0', expire int(11) NOT NULL default '0', message text NOT NULL, reason text NOT NULL, PRIMARY KEY (id), KEY active (active)) ENGINE=MyISAM
2. Error
CREATE TABLE 4images_ban_logs ( id mediumint(10) NOT NULL auto_increment, `date` int(11) NOT NULL default '0', ban_id mediumint(12) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', ip tinytext NOT NULL, uri varchar(255) NOT NULL default '', PRIMARY KEY (id)) ENGINE=MyISAM
3. Done
INSERT INTO `4images_settings` ( `setting_name` , `setting_value` ) VALUES ('look_hostname', '1')
4. Done
INSERT INTO `4images_settings` ( `setting_name` , `setting_value` ) VALUES ('ban_update', '0')
Why??!??
help me please...
b.o.fan