database error

hadi

vot ,please help me to install n solve my problem... before this i use discuzx2 and i dont have problem to install it and it working but when i remove x2 and install x2.5 my database error and i remove again and install it again but this time the entire page is blank... please help me install x2.5 ,im new to this.....

vot

What the Version/Release/Revision used?

hadi

i download from this thread here ,anyway can you help me to install it.. i can give username and pass .....i have try so many time and not working....... im new to this

vot

We are ready to help you by advices for free.
But if you want a JOB from our members - it is not for free:
http://codersclub.org/discuzx/fo ... &extra=page%3D1

My advice:
Edit the install/data/install.sql
Find this code:

1. DROP TABLE IF EXISTS pre_common_template_block;
   
2. CREATE TABLE pre_common_template_block (
   
3. targettplname varchar(255) NOT NULL DEFAULT '',
   
4. tpldirectory varchar(255) NOT NULL DEFAULT '',
   
5. bid int(11) unsigned NOT NULL DEFAULT '0',
   
6. PRIMARY KEY (targettplname,tpldirectory,bid),
   
7. KEY bid (bid)
   
8. ) TYPE=MyISAM;
   

Copy the Code

Replace it with the next:

1. DROP TABLE IF EXISTS pre_common_template_block;
   
2. CREATE TABLE pre_common_template_block (
   
3. targettplname varchar(255) NOT NULL DEFAULT '',
   
4. tpldirectory varchar(255) NOT NULL DEFAULT '',
   
5. bid int(11) unsigned NOT NULL DEFAULT '0',
   
6. KEY (targettplname),
   
7. KEY (tpldirectory),
   
8. KEY bid (bid)
   
9. ) TYPE=MyISAM;
   

Copy the Code

And retry to install...

hadi

how to reinstall it...............

vot

how to reinstall it

Just go to yoursite.tld/install/

vot

Updated in repository.
#110

hadi

tq so much for your advise vot...appreciate it

hadi

sorry vot but my site still like that when i change the code that u advice.............. here the error that appear

                     run_sql_error

• SQL:CREATE TABLE pre_common_diy_data ( targettplname varchar(255) NOT NULL DEFAULT '', tpldirectory varchar(255) NOT NULL DEFAULT '', primaltplname varchar(255) NOT NULL DEFAULT '', diycontent mediumtext NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', uid int(11) unsigned NOT NULL DEFAULT '0', username varchar(255) NOT NULL DEFAULT '', dateline int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (targettplname,tpldirectory)) ENGINE=MYISAM DEFAULT CHARSET=utf8
  Error:Specified key was too long; max key length is 1000 bytes
  Errno:1071
  

run_sql_error

• SQL:REPLACE INTO pre_common_diy_data (targettplname, tpldirectory, primaltplname, diycontent) VALUES ('group/index', './template/default', 'group/index', 'a:3:{s:8:\"spacecss\";s:133:\"#portal_block_1 .dxb_bc {margin-left:0px !important;}#portal_block_2 .dxb_bc {font-size:14px !important;margin-left:10px !important;}\";s:10:\"layoutdata\";a:10:{s:4:\"diy1\";s:0:\"\";s:13:\"diycontenttop\";s:0:\"\";s:4:\"diy5\";a:1:{s:17:\"frame`framee6gQb5\";a:3:{s:4:\"attr\";a:4:{s:4:\"name\";s:11:\"framee6gQb5\";s:8:\"moveable\";s:4:\"true\";s:9:\"className\";s:28:\"frame move-span cl frame-1-1\";s:6:\"titles\";s:0:\"\";}s:23:\"column`framee6gQb5_left\";a:2:{s:4:\"attr\";a:2:{s:4:\"name\";s:16:\"framee6gQb5_left\";s:9:\"className\";s:18:\"column frame-1-1-l\";}s:20:\"block`portal_block_1\";a:1:{s:4:\"attr\";a:3:{s:4:\"name\";s:14:\"portal_block_1\";s:9:\"className\";s:15:\"block move-span\";s:6:\"titles\";s:0:\"\";}}}s:25:\"column`framee6gQb5_center\";a:2:{s:4:\"attr\";a:2:{s:4:\"name\";s:18:\"framee6gQb5_center\";s:9:\"className\";s:18:\"column frame-1-1-r\";}s:20:\"block`portal_block_2\";a:1:{s:4:\"attr\";a:3:{s:4:\"name\";s:14:\"portal_block_2\";s:9:\"className\";s:15:\"block move-span\";s:6:\"titles\";s:0:\"\";}}}}}s:13:\"diycommendtop\";s:0:\"\";s:14:\"diycategorytop\";s:0:\"\";s:16:\"diycontentbottom\";s:0:\"\";s:10:\"diysidetop\";s:0:\"\";s:13:\"diysidemiddle\";s:0:\"\";s:13:\"diysidebottom\";s:0:\"\";s:4:\"diy4\";s:0:\"\";}s:5:\"style\";s:0:\"\";}')
  Error:Table 'kembarah_forum.pre_common_diy_data' doesn't exist
  Errno:1146
  

kaaleth

• 1. 
     
  2. <font color="rgb(102, 102, 102)"><font face="Verdana, Arial, Tahoma, sans-serif"><font><b>run_sql_error</b><ul><li><i>SQL:CREATE TABLE pre_common_diy_data ( targettplname varchar(255) NOT NULL DEFAULT '', tpldirectory varchar(255) NOT NULL DEFAULT '', primaltplname varchar(255) NOT NULL DEFAULT '', diycontent mediumtext NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', uid int(11) unsigned NOT NULL DEFAULT '0', username varchar(255) NOT NULL DEFAULT '', dateline int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (targettplname,tpldirectory)) ENGINE=MYISAM DEFAULT CHARSET=utf8
     
  3. Error:Specified key was too long; max key length is 1000 bytes
     
  4. Errno:1071</i>
     
  5. </li></ul></font></font></font>
     
  6. <font color="rgb(102, 102, 102)"><font face="Verdana, Arial, Tahoma, sans-serif"><font><b>run_sql_error</b><ul><li><i>SQL:REPLACE INTO pre_common_diy_data (targettplname, tpldirectory, primaltplname, diycontent) VALUES ('group/index', './template/default', 'group/index', 'a:3:{s:8:"spacecss";s:133:"#portal_block_1 .dxb_bc {margin-left:0px !important;}#portal_block_2 .dxb_bc {font-size:14px !important;margin-left:10px !important;}";s:10:"layoutdata";a:10:{s:4:"diy1";s:0:"";s:13:"diycontenttop";s:0:"";s:4:"diy5";a:1:{s:17:"frame`frameDj2lOY";a:3:{s:4:"attr";a:4:{s:4:"name";s:11:"frameDj2lOY";s:8:"moveable";s:4:"true";s:9:"className";s:28:"frame move-span cl frame-1-1";s:6:"titles";s:0:"";}s:23:"column`frameDj2lOY_left";a:2:{s:4:"attr";a:2:{s:4:"name";s:16:"frameDj2lOY_left";s:9:"className";s:18:"column frame-1-1-l";}s:20:"block`portal_block_1";a:1:{s:4:"attr";a:3:{s:4:"name";s:14:"portal_block_1";s:9:"className";s:15:"block move-span";s:6:"titles";s:0:"";}}}s:25:"column`frameDj2lOY_center";a:2:{s:4:"attr";a:2:{s:4:"name";s:18:"frameDj2lOY_center";s:9:"className";s:18:"column frame-1-1-r";}s:20:"block`portal_block_2";a:1:{s:4:"attr";a:3:{s:4:"name";s:14:"portal_block_2";s:9:"className";s:15:"block move-span";s:6:"titles";s:0:"";}}}}}s:13:"diycommendtop";s:0:"";s:14:"diycategorytop";s:0:"";s:16:"diycontentbottom";s:0:"";s:10:"diysidetop";s:0:"";s:13:"diysidemiddle";s:0:"";s:13:"diysidebottom";s:0:"";s:4:"diy4";s:0:"";}s:5:"style";s:0:"";}')
     
  7. Error:Table 'dx25ml.pre_common_diy_data' doesn't exist
     
  8. Errno:1146</i></li></ul></font></font></font>

  Copy the Code

Not sure if fixed... board won't run.