Serendipity Forums

SQL query:

####
#### Important notes:
#### If you make modifications (additions, subtractions), please
#### make the appropriate change in the db_update files. If you don't
#### know the syntax for a different database, e-mail the list for
#### help.
####
####
#
# Table structure for table '{PREFIX}authors'
#
CREATE TABLE {PREFIX}authors(

realname varchar( 255 ) NOT NULL default '',
username varchar( 20 ) default NULL ,
PASSWORD varchar( 32 ) default NULL ,
authorid{AUTOINCREMENT}{ PRIMARY },
mail_comments int( 1 ) default '1',
mail_trackbacks int( 1 ) default '1',
email varchar( 128 ) NOT NULL default '',
userlevel int( 4 ) {UNSIGNED} NOT NULL default '0',
right_publish int( 1 ) default '1'
){UTF_8};



MySQL said:

#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 '{PREFIX}authors (
realname varchar(255) NOT NULL default '',
username varcha' at line 1



help plaese

i trid

garvinhicking wrote:Don'T execute the db.sql file manually. Use the Serendipity installer, it does all that automatically. Just open http://yourhost/serendipity/ and everything will be automatic from there on.

It's all easier than you're thinking

Best regards,
Garvin

in
http://board.s9y.org/viewtopic.php?t=1043

but i got a blank page!

Hi!

So if you call your URL for where you installed s9y into, you only get a blank page?

If you view the HTML source of the blank page, is it blank as well?

In that case, a fully blank page usually means a fatal PHP error. Can you check your Apache/PHP Error log?

Best regards,
Garvin