Mysql problem!

[Brandonii]

Well, i tried to run something via phpmyadmin, and it says this:

 

SQL query:

 

CREATE TABLE `phpbb_announcement_centre` (

`announcement_show` tinyint( 1 ) NOT NULL ,

`announcement_enable` tinyint( 1 ) NOT NULL ,

`announcement_enable_guests` tinyint( 1 ) NOT NULL ,

`announcement_show_birthdays` tinyint( 1 ) NOT NULL ,

`announcement_birthday_avatar` tinyint( 1 ) NOT NULL ,

`announcement_draft` text NOT NULL ,

`announcement_text` text NOT NULL ,

`announcement_text_guests` text NOT NULL ,

`announcement_title` varchar( 255 ) NOT NULL default '',

`announcement_title_guests` varchar( 255 ) NOT NULL default '',

`announcement_show_group` varchar( 255 ) NOT NULL default ''

) CHARACTER SET utf8 COLLATE utf8_bin

 

MySQL said: Documentation

#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 'COLLATE utf8_bin' at line 13

 

 

Also check out allblab.com and read the mysql error there.

[Brandonii]

now my forum is saying

 

General Error

SQL ERROR [ mysql4 ]

 

Table 'db254922863.phpb_chat' doesn't exist [1146]

 

SQL

 

SELECT * FROM phpb_chat ORDER BY message_id DESC LIMIT 25

 

BACKTRACE

 

FILE: includes/db/mysql.php

LINE: 158

CALL: dbal_mysql->sql_error()

 

FILE: includes/db/mysql.php

LINE: 205

CALL: dbal_mysql->sql_query()

 

FILE: includes/db/dbal.php

LINE: 159

CALL: dbal_mysql->_sql_query_limit()

 

FILE: shout.php

LINE: 54

CALL: dbal_mysql->sql_query_limit()

 

FILE: index.php

LINE: 47

CALL: include('shout.php')

 

 

but it does exsist

[Chicken Little]

I was able to create the table with no problems and the query looks ok. I'm using phpMyAdmin 2.8.2.4 and MySQL 5.0. Can you post the entire sql and/or the mysql.php file.