Error in database query (logs.php) after upgrade to r135

General forum for discussions regarding UTStatsDB
zzz0o
Posts: 5
Joined: Fri Oct 24, 2008 3:08 am
Location: Ukraine
Contact:

Error in database query (logs.php) after upgrade to r135

Postby zzz0o » Tue Jan 11, 2011 1:17 am

Code: Select all

*Error in database query: 'SELECT se_num,se_title,se_trigtype,se_trignum FROM ut_special ORDER BY se_num' 1054: Unknown column 'se_trigtype' in 'field list'

Code: Select all

mysql> describe ut_special; +----------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-----------------------+------+-----+---------+----------------+ | se_num | smallint(5) unsigned | NO | PRI | NULL | auto_increment | | se_title | varchar(30) | NO | MUL | | | | se_desc | varchar(175) | NO | | | | | se_total | mediumint(8) unsigned | NO | | 0 | | +----------+-----------------------+------+-----+---------+----------------+
And that is true. Column se_trigtype doesn't exsists. I did updatedb from admin page after upgrading and no error reported.

Thanks in advice.

Panther
Site Admin
Posts: 500
Joined: Sat Dec 08, 2007 12:51 am
Contact:

Re: Error in database query (logs.php) after upgrade to r135

Postby Panther » Tue Jan 11, 2011 8:36 am

That's because all the new changes have not been fully implemented in the versions of the files currently on the Subversion server. You would either need to stick with the releases, or finish the modifications I started and send in the completed version...

zzz0o
Posts: 5
Joined: Fri Oct 24, 2008 3:08 am
Location: Ukraine
Contact:

Re: Error in database query (logs.php) after upgrade to r135

Postby zzz0o » Fri Jan 14, 2011 3:29 am

Roolbacked to previuosly backup state(3.06) all scriptes and database. Get same error with ereg_replace php-function.
Update only 'includes/main.inc.php' from revision 135. Error is gone, and logs are normally parsing now.

Thanks for help.


Return to “UTStatsDB”