style table error

[samerss]

Hello everyone,
I'm facing a strange error in db. when I try to create a new style it always takes the id zero (styleid=0), and I get this error (you cannot assign main em>stylename to one of its branches ). but the style is created anyway. this is the case with creating a style without parents.
if I create a child style, I dont get that error but the id will be set to zero too.

and If I try to delete the new style with id=0 from admincp, I get and error says: there is no style with id=0. thought, it's still shown in admincp.

I tried to use tools.php to repair the tables and the style, but it didn't work.
I tried to run upgrade, but it didn't work either.

repair table gives this note: Table does not support optimize, doing recreate + analyze instead
after I create the style with id=0 I get mysql errors in all sections of "Styles and Templates":
Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND t2.title IS NULL ORDER BY title, ordercontrol' at line 4 in ..../includes/class_core.php on line 1393
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT t1.templateid, t1.title, INSTR(',0, -1,', CONCAT(',', t1.styleid, ',') ) AS ordercontrol, t1.styleid
FROM template AS t1
LEFT JOIN template AS t2 ON (t2.title=t1.title AND t2.styleid = -1)
WHERE t1.styleid IN (0,) AND
t2.title IS NULL
ORDER BY title, ordercontrol;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND
t2.title IS NULL
ORDER BY title, ordercontrol' at line 4
Error Number : 1064
Request Date : Tuesday, March 4th 2014 @ 01:01:29 PM
Error Date : Tuesday, March 4th 2014 @ 01:01:29 PM
Script : http://arabic.rt.com/forum/admincp/template.php?do=modify
Referrer : http://arabic.rt.com/forum/admincp/index.php?do=nav
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.5.34-MariaDB-wsrep-log

P.S. server Linux, mysql version 5.5.34
php version: 5.4.24
forum language: Arabic
no live version yet.

thanks.

Samer

[Lynne]

Moved to vB4 section.

Check Maintenance > Diagnostics > Suspect File Version. Are any DEFAULT vbulletin files listed as "not containing expected contents" or as "expecting version 4.2.2, found verion 4.x.x" ?

[ForceHSS]

Go to your phpmyadmin and check the template table and see the title table and see if any are empty

[samerss]

I didn't find any file with "not containing expected contents" or any other notices there.
also with the templates I didn't find anyone with an empty title.

[ForceHSS]

You did check all pages as i have over 100 and only have one skin installed