Bug (done?)

New install failing on "add db_version entry" / #6574

MoveBookmark

Summary

v0.081 - more fixes and tuned filtering of recent changes
done?
Jun 5, 2008
30 min ... 60 min
100%
Jul 25, 2008
Jun 5, 2008 / jtanen
Jul 29, 2008 / guest
View previous 11 versions
cody-somerville
 

Attached files

No files uploaded
When I try to run a new install, I get a failure on add db_version entry.

My environment:
  • Suse Linux Enterprise Server 10 SP2, fully updated
  • Apache 2.2.3
  • MySQL 5.0.26
  • PHP5 5.2.5 with Suhosin-Patch 0.9.6.2
Tried with both external MySQL instance (we use a centralized MySQL box for production databases) and the localhost MySQL instance; both gave same result (same version of MySQL on both). Tried with an existing streber database, as well as without one.

Database is setup with a user account specifically for streber with full permissions on the streber database; does not have GRANT, since I assume that isn't needed.

Issue report

Major
Always
Suse Linux Enterprise Server 10 SP2
0.0803
??
Run the web-based install
Receive FAILED status on add db-version entry due to SQL-Error:

from /install/install.php

Query error: INSERT into streb_db (id,version,version_streber_required,created) VALUES(1,'0.0803','0.0803',NOW() )
 

7 Comments

jtanen

Jun 5, 2008
Believe I found problem
Problem appears to be that I added streb_ to database tables in web GUI, but tables were created without that prepended. Once I took out that marker (which was not needed, anyway) and re-ran, I hit one more error from the problematic previous install. I then dropped all tables created in the faulty install, re-ran, and got a successful install.

guest

Jun 6, 2008
hmm...
But this sounds like the installation procedure has a problem with the database prefix?

Cody? What do you think about this?

cody-somerville

Jun 6, 2008
View comment
Someone else reported this bug but I can't seem to find it at the moment. Unfortunate bug. Current workaround is to not use a prefix.

guest

Jun 9, 2008
Installation issue

After reading the post about how mature streber is and the versioning schema, and how this would be good for the project, you most be joking then in leaving the installation like it is..

I had the same issue with a blank install on my hosting provider. Maybe some components are mature, but installation screens aren't. If you don't mention this (in a small ballon tip?), then publishing with-out testing like this, is not good option at all. Still considering going step up to version 1.0 ? Think again...

pixtur

Jun 9, 2008
point taken...

maniadmin

Jul 24, 2008
Seems to be similar to my issue?
I really dunno, but this might be related to my install problem, as documented here: www.streber-pm.org/6718

What I didn't mention in that bug post, was that I ALSO am using prefixes on my DB names and DB user names. NOT that I have an option to do otherwise... cPanel (yes, shared hosting...) automatically ads my username as a prefix to both.

So I really don't know, but thought this sounded similar... I'm trying to get streber up and running for the first time. No luck yet. Usually I would have given up long ago, with software that doesn't even run out of the box by following instructions. BUT I do have faith that this is a nice piece of work, and worth my time to trouble shoot.

???
Am I on the right track?
M.M.

guest

Jul 29, 2008
View comment
Hi,

I plan to release a new version super soon that will fix this very unfortunate regression.

Cheers,

Cody
 
 

Comment / Update