SOLVED: Installation Error »  Show posts from    to     

Icy Phoenix


Old Support Topics - SOLVED: Installation Error



devildog [ Fri 09 Jan, 2009 00:27 ]
Post subject: SOLVED: Installation Error
Greetings!

I've been trying to install IP for about the last hour and have run into some problems.

First, I downloaded the fix for the schemas. After messing with that, I found that it didn't create one of the tables. I got that all squared away!!

Now I am getting this error:

An error occured while trying to update the database.
Unknown column 'group_color' in 'field list'

I've searched the board and haven't come up with any solutions.

Any Thoughts?


Limun [ Fri 09 Jan, 2009 01:04 ]
Post subject: Re: Installation Error
you trying a fresh instal or you are upgrading ?


devildog [ Fri 09 Jan, 2009 01:31 ]
Post subject: Re: Installation Error
It's a fresh install. I forgot to mention that in my previous post!


Limun [ Fri 09 Jan, 2009 10:43 ]
Post subject: Re: Installation Error
devildog wrote: [View Post]
It's a fresh install. I forgot to mention that in my previous post!

ok,

what did you exact downloated ?
what "fix for all schemas" u mean ?

anyway try to empty all tables from your database (with phpmyadmin or cp on server) and try install again


devildog [ Fri 09 Jan, 2009 13:55 ]
Post subject: Re: Installation Error
I've dumped the tables from MySql about 5 or 6 times and still get the error.

I downloaded the schema fis from this thread: http://www.icyphoenix.com/viewtopic.php?f=4&t=2520


Lopalong [ Fri 09 Jan, 2009 14:23 ]
Post subject: Re: Installation Error
What version of Icy Phoenix are you trying to install, and did you upload it using the correct ftp Mode ?


Limun [ Fri 09 Jan, 2009 14:23 ]
Post subject: Re: Installation Error
devildog wrote: [View Post]
I've dumped the tables from MySql about 5 or 6 times and still get the error.

I downloaded the schema fis from this thread: http://www.icyphoenix.com/viewtopic.php?f=4&t=2520


why you need that , try just create database from your server acp , and than install icyphoneix ....
and read instructions about -Fresh Installation- here http://www.icyphoenix.com/viewtopic.php?f=1&t=3736


devildog [ Fri 09 Jan, 2009 14:41 ]
Post subject: Re: Installation Error
I needed that because it would not allow Full Text Search when I started installation. I used that schema and had to alter it because it diddn't create one of the tables.

I've done everything that the instructions say. I'm running a server with Server 2003 and have made sure that all the permissions are right. I've deleted the install package, redownloaded it and dumped the tables (several times) to no avail.

Here is a screenshot of the error:

ip2

Lopalong wrote: [View Post]
What version of Icy Phoenix are you trying to install, and did you upload it using the correct ftp Mode ?


I'm using the latest version that is available for download: 1.2.0.27. I'm hosting the site on my own server, so there was no need to ftp. The initial screen that checks permission's found no errors.


Limun [ Fri 09 Jan, 2009 16:06 ]
Post subject: Re: Installation Error
devildog wrote: [View Post]
I needed that because it would not allow Full Text Search when I started installation. I used that schema and had to alter it because it diddn't create one of the tables.
.


try this :
use original schema but before :
open /install/schemas/mysql_schema.sql

find
Spoiler: [ Show ]


replace with
Spoiler: [ Show ]


find and delete
Spoiler: [ Show ]


and than try install again ...
let us know if helped


devildog [ Fri 09 Jan, 2009 18:38 ]
Post subject: Re: Installation Error
Ok.. I followed thos stes and was able to move firther along. I got a blob/Text error next and was able to resolve that.

Now I have this error:

Code: [Hide]
  1. An error occurred trying to update the database  
  2. 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 ''', sort INT(11) DEFAULT '', cat INT(11) DEFAULT '', hacklist TINYINT(1) DEFA' at line 8 


Limun [ Fri 09 Jan, 2009 19:22 ]
Post subject: Re: Installation Error
devildog wrote: [View Post]
Ok.. I followed thos stes and was able to move firther along. I got a blob/Text error next and was able to resolve that.

Now I have this error:

Code: [Hide]
  1. An error occurred trying to update the database  
  2. 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 ''', sort INT(11) DEFAULT '', cat INT(11) DEFAULT '', hacklist TINYINT(1) DEFA' at line 8 


can you post your modified mysql_schema.sql ?
and did you also replaced db_update_000.sql with original ?


devildog [ Fri 09 Jan, 2009 20:48 ]
Post subject: Re: Installation Error
I put the original db_mysql_000.sql file back. Here is the mysql_schema.sql file.


Limun [ Fri 09 Jan, 2009 22:33 ]
Post subject: Re: Installation Error
try this one again

lets see ...


devildog [ Fri 09 Jan, 2009 23:35 ]
Post subject: Re: Installation Error
Nope.. Still the same thing.

I really appreciate the help! This is by far the best support I've ever received from a forum! You guys are tops in my book!


Limun [ Sat 10 Jan, 2009 00:10 ]
Post subject: Re: Installation Error
try this (change both files)


devildog [ Sat 10 Jan, 2009 00:54 ]
Post subject: Re: Installation Error
I tried that, and it gave me the same error. I changed it to this and got by that error.

Code: [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: [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.


Limun [ Sat 10 Jan, 2009 01:07 ]
Post subject: Re: Installation Error
can you try to create only this table with phpmyadmin ?


devildog [ Sat 10 Jan, 2009 01:36 ]
Post subject: 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.


Limun [ Sat 10 Jan, 2009 02:05 ]
Post subject: Re: Installation Error
i have no ideas for now anymore


devildog [ Sat 10 Jan, 2009 02:20 ]
Post subject: 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?


DWho [ Sat 10 Jan, 2009 11:29 ]
Post subject: 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..



devildog [ Sat 10 Jan, 2009 15:53 ]
Post subject: 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!!




Powered by Icy Phoenix