Icy Phoenix

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?

you trying a fresh instal or you are upgrading ?

It's a fresh install. I forgot to mention that in my previous post!

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

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

What version of Icy Phoenix are you trying to install, and did you upload it using the correct ftp Mode ?

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

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:

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.

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


replace with


find and delete


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

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:

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: [Download] [Hide]

Code: [Download] [Show]

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 ?

I put the original db_mysql_000.sql file back. Here is the mysql_schema.sql file.

try this one again

lets see ...

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!

try this (change both files)