error when Import dp file

Having trouble installing serendipity?
Post Reply
Ln X
Posts: 2
Joined: Mon Feb 19, 2007 5:32 am

error when Import dp file

Post by Ln X »

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
Ln X
Posts: 2
Joined: Mon Feb 19, 2007 5:32 am

Post by Ln X »

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!
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply