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 6, 2008 / jtanen
Jul 25, 2008 / maniadmin
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:Believe I found problem

4 years ago

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:hmm...

4 years ago - Delete

But this sounds like the installation procedure has a problem with the database prefix?

Cody? What do you think about this?

cody-somerville:

4 years ago

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:Installation issue

4 years ago - Delete


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:point taken...

4 years ago


maniadmin:Seems to be similar to my issue?

4 years ago

I really dunno, but this might be related to my install problem, as documented here: http://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:

4 years ago - Delete

Hi,

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

Cheers,

Cody

Add Comment