r12: Database error

charafweb

Hello Vot,
There is a problem with the last revision (r12), after i installed i got this message error:

1. (1146) Table 'ultrax25.common_template_block' doesn't exist.

Copy the Code

ultrax25 is my database name.


Thanks

vot

It is strange...
because of the table creating is exists in install.sql:

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,bid),
   
7.   KEY bid (bid)
   
8. ) TYPE=MyISAM;

Copy the Code

What the table prefix you have set when install?

charafweb

I left the default prefix: pre_

charafweb

Here are more screenshots:
setings:



after this page:



I got this message:



After rafreshing (F5) I got this



After a second F5 i got this:

vot

Try to modify the install.sql:

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

Copy the Code

charafweb

the same problem

vot

I have understanded the problem!
It is a bug in the X2.5 table driver: table_common_template_block.php
It uses this command:

1.                 return $tpl ? DB::delete($this->_table, DB::field('targettplname', $tpl)) : false;

Copy the Code

But "$this->_table" does NOT contain the real table prefix!
I think, this must be modified to:

1.                 return $tpl ? DB::delete(DB::table($this->_table), DB::field('targettplname', $tpl)) : false;

Copy the Code

The same bug presents in many other places!
If you see any direct using of "$this->_table",
it must be replaced with "DB::table($this->_table)"

charafweb

I did as you said, I replaced all "$this->_table" with "DB::table($this->_table)", in all files (using search and replace, a Funduc soft). At the end of creating tables, there was a message error (in red), that i couldn't read because the page redirect quickly to the last step (page) where it's said "Installation successfully completed! Click here to enter your Discuz! X2". When I clicked the link a got a blank page. There is something wrong!

vot

said "Installation successfully completed!

This is nice

Click here to enter your Discuz! X2". When I clicked the link a got a blank page. There is something wrong!

Check the language pack...

charafweb

Hi,
I made a fresh install and recorded my screen to take a screenshot of the error message:



What language pack you meant? I did not change anything in your files (donloaded from svn repository), except repalcing all "$this->_table" with "DB::table($this->_table)"