SOLVED: Installation Error

The time now is Thu 18 Apr, 2024 06:48 • All times are UTC + 1 Hour [DST enabled]

SOLVED: Installation Error

Page 2 of 2
Goto page Previous 1, 2

devildog

Joined: January 2009
Posts: 30
Location:

Re: Installation Error

I tried that, and it gave me the same error. I changed it to this and got by that error.

Code: [Download] [Hide] [Select]

    long_desc TEXT,

    sort INT(11),

    cat INT(11),

Now I'm getting this:

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 '
    hack_version VARCHAR(32),
    hack_dl_url TINYTEXT DEFAULT '0',
    test varchar(' at line 14

Seems that the problem is with this part of the that file:

Code: [Download] [Hide] [Select]

CREATE TABLE phpbb_downloads (

    id INT(11) auto_increment NOT NULL,

    description VARCHAR(255),

    file_name VARCHAR(255) DEFAULT '',

    klicks INT(11) DEFAULT '0',

    free TINYINT(1) DEFAULT '0',

    extern TINYINT(1) DEFAULT '0',

    long_desc TEXT DEFAULT '',

    sort INT(11) DEFAULT '0',

    cat INT(11) DEFAULT '0',

    hacklist TINYINT(1) DEFAULT '0',

    hack_author VARCHAR(255) DEFAULT '',

    hack_author_email VARCHAR(255) DEFAULT '',

    hack_author_website TINYTEXT DEFAULT '',

    hack_version VARCHAR(32) DEFAULT '',

    hack_dl_url TINYTEXT DEFAULT '',

    test varchar(50) DEFAULT '',

    req TEXT DEFAULT '',

    todo TEXT DEFAULT '',

    warning TEXT DEFAULT '',

    mod_desc TEXT DEFAULT '',

    bbcode_uid VARCHAR(10) DEFAULT '',

    mod_list TINYINT(1) DEFAULT '0',

    file_size BIGINT(20) NOT NULL DEFAULT '0',

    change_time INT(11) DEFAULT '0',

    add_time INT(11) DEFAULT '0',

    rating SMALLINT(5) DEFAULT '0' NOT NULL,

    file_traffic BIGINT(20) NOT NULL DEFAULT '0',

    overall_klicks INT(11) DEFAULT '0',

    approve TINYINT(1) DEFAULT '0',

    add_user MEDIUMINT(8) DEFAULT '0',

    change_user MEDIUMINT(8) DEFAULT '0',

    last_time INT(11) DEFAULT '0',

    down_user MEDIUMINT(8) DEFAULT '0' NOT NULL,

    thumbnail VARCHAR(255) DEFAULT '' NOT NULL,

    broken TINYINT(1) NOT NULL DEFAULT 0,

PRIMARY KEY (id)

);

I've tried changing the parts around line 14 and can't get by that error.

#16 Sat 10 Jan, 2009 00:54

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Limun Joined: January 2008 Posts: 1334 Location: [Censor]	Re: Installation Error can you try to create only this table with phpmyadmin ? ____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
#17 Sat 10 Jan, 2009 01:07

devildog Joined: January 2009 Posts: 30 Location:	Re: Installation Error I tried to create the table in MySql Query Browser. No matter what I did with those lines, it wouldn't creat the table. I guess I could create the table without those columns and then add them in.
#18 Sat 10 Jan, 2009 01:36

Limun Joined: January 2008 Posts: 1334 Location: [Censor]	Re: Installation Error i have no ideas for now anymore ____________ We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
#19 Sat 10 Jan, 2009 02:05

devildog Joined: January 2009 Posts: 30 Location:	Re: Installation Error I'm not sure either.. I do appreciate your help tho! Thanks! After a few hours of messing with the mysql_schema.sql, I got it to create all the tables. Now, I get a HTTP 500 Error saying the website can't be displayed. Is there something else I need to try and fix?
#20 Sat 10 Jan, 2009 02:20

DWho

Joined: August 2006
Posts: 1307
Location:

hampshire

Re: Installation Error

if you are using a windows server...remove the .htaccess file from the root of your icy site...

if you are not using a windows server I am not sure what is causing that problem..

____________
Mods and themes for Icy Phoenix 1.3

IcyPhoenix UK is off-line permanently due to lack of time to update mods.
if anyone is interested in my templates I will upgrade them to Icy 2.0.

#21 Sat 10 Jan, 2009 11:29

devildog

Joined: January 2009
Posts: 30
Location:

Re: Installation Error

I tried removing the .htaccess file and still get the HTTP 500 error, so I'm a bit confused of what is going wrong! I'm sure we'll figure it out sooner or later!

I also noticed that it's not adding some of the information to the tables. or writing the config.php file...

EDIT:

Just a bit more info...

I am having the www.thenortherntundra.com forwarded to www2.thenortherntundra.com:8000.  I'm not sure if this is causing any of the problems that I am having.  Now, the scripts work to create the database and populate it, but takes me to a HTTP 500 error screen.  It seems that it won't finish the installation.

Limun has been working with me most of the day andwe haven't been able to come up with any solutions.  Does anyone else have any suggestions?

EDIT #2:  Seems the port was the problem.  I was able to install on 127.0.0.1 and then copied and pasted into the folder I needed to.

Thanks for everybody's help!!

#22 Sat 10 Jan, 2009 15:53

Page 2 of 2
Goto page Previous 1, 2

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Thu 18 Apr, 2024 06:48 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events