Pagina 1 din 1
Cum pot sa mut un forum phpbb3
Scris: 19-Feb-2008, 11:00:53
de |Robert|
Ma confrunt cu o problema... am schimbat hostingul si am salvat baza de date de pe host 1... nu reusesc sa pun baza de date pe host 2. imi da urmatoarea eroare in phpMyAdmin: ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; sau 'collate utf8_bin NOT NULL default '',
`is_global` tinyint(1)
ce pot sa fac ?
Multumesc anticipat
Scris: 19-Feb-2008, 17:53:07
de Myky
Sterge toate tabelele din PHPMyAdmin. Si incearca atunci.
Scris: 19-Feb-2008, 18:15:38
de |Robert|
nu am inca nici un tabel... am facut doar baza de date... restore sau import trebuie sa faca acest lucru... dar... nu face nimica din cauza erorii utf8
Scris: 19-Feb-2008, 19:22:45
de shocker
Pune un screenshot sa vedem exact ce iti arata
Scris: 19-Feb-2008, 20:07:12
de |Robert|
Error
SQL query:
CREATE TABLE `phpbb3_acl_groups` (
`group_id` mediumint( 8 ) unsigned NOT NULL default '0',
`forum_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_option_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_role_id` mediumint( 8 ) unsigned NOT NULL default '0',
`auth_setting` tinyint( 2 ) NOT NULL default '0',
KEY `group_id` ( `group_id` ) ,
KEY `auth_opt_id` ( `auth_option_id` ) ,
KEY `auth_role_id` ( `auth_role_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 10
sau
Error
SQL query:
CREATE TABLE `phpbb3_zebra` (
`user_id` mediumint( 8 ) unsigned NOT NULL default '0',
`zebra_id` mediumint( 8 ) unsigned NOT NULL default '0',
`friend` tinyint( 1 ) unsigned NOT NULL default '0',
`foe` tinyint( 1 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `user_id` , `zebra_id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 7
cam astea sunt eroriile... la orice tabel vrau sa creez.... din backup-ul facut...