Installer error

[sc7676]

Hi -

I hope someone knows the solution to this problem.

1> The following error shows up after the installer checks and passed all server requirements. First couple of errors, the installer could not find tables in the database. I created those tables. Now this error comes up. I made sure the column was set to 'e.id' but unfortunately no such luck. Why does this installer have problems with fields and tables? I hope someone knows the answer to this problem.
DevblocksPlatform:Unknown column 'e.id' in 'field list'



Best Regards

[jstanden]

Hey there,

I haven't heard of this coming up before.

Can you verify some things?


What database driver and version are you using? MySQL5, PostgreSQL8, etc.
Did you start from a completely clean database? (You don't want to enter your Cerb3 DB details)Those should help point me in the right direction.

Thanks!

[sc7676]

MySQL 5

The database is empty.

The installer has problems. I never seen an installer like this one that states tables and fields already exists when they don't actually exist.


What cerb3 details do you mean?


Regards

[jstanden]

Hey there!

I'm a bit confused by your posts.

First you said:

First couple of errors, the installer could not find tables in the database. I created those tables

Now you're saying:

The database is empty.


Can you open your /cerb4/framework.config.php file and connect to your database using those exact APP_DB_* settings?

Something like:
mysql -u user -ppassword database

Once connected, issue the SQL command:
SHOW TABLES

What is the output?

Thanks!

[sc7676]

the main problem is the installer cannot write tables to the database. I had to manually put the tables in. Then, the installer stated a column already exist. So I manually inserted that column. No such luck with the column. The installer keeps saying the column already exist. This is why I say the installer has problems with its auto-creation of tables and columns. Note, I passed the first error by manually inserted the tables. I don't understand why the installer says a column already exists. I manually inserted it and empty it but nothing. The installer keeps stating the column already exists. I am getting no place with this installer. What is your manual procedure to install this program?


Regards

[Hildy]

the main problem is the installer cannot write tables to the database. I had to manually put the tables in.
The installer is part of Cerberus. There's no manual install procedure, because if the installer does not have proper access to the db, then no part of Cerberus will, and it's just not going to work. Like Jeff said, you need to be sure that the *exact* database information as present in the framework.config.php file gives full access to the database.