Ticket #393 (closed Bug report: fixed)

Opened 1 year ago

Last modified 1 year ago

DB schema problems

Reported by: anonymous Assigned to:
Priority: blocker Milestone: Not yet assigned to a Milestone
Component: Auth server, Authentication, permissions and access control Keywords: parse error database schema security.php
Cc:

Description

I keep getting a parse error when getting to the database initalisation step when running install.php. I found documentation that suggests asking for help.

The exact error is:

On localhost, Database wifidog exists and is at schema version 56. The required schema version is 57. Triggering database schema upgrade

Parse error: parse error, unexpected T_ARRAY, expecting '&' or T_VARIABLe in /var/www/wifidog-auth/wifidog/classes/Security.php on line 65.

I ran svn and checked out the latest build (1300) and still not able to get past this point.

Attachments

Change History

(follow-up: ↓ 2 ) 10/11/07 11:38:30 changed by jay_alpes de cyberdahu.com : futur les Orres sans Fil

I've the same problem. You can change wifidog-postgres-initial-data.sql. For me : vim /var/www/wifidog-auth/sql/wifidog-postgres-initial-data.sql line 252 you put "57" in the place of "56". But I'm still have a problem in another page after : "Fatal error: Call to undefined function pg_escape_string() in /var/www/wifidog-auth/wifidog/classes/AbstractDb.php on line 359"

(in reply to: ↑ 1 ) 10/12/07 03:23:30 changed by jay_alpes de cyberdahu.com : futur les Orres sans Fil

ok it's good for me : you change your wifidog-postgres-initial-data.sql, then you drop your database wifidog and you restart the install of wifidog in your brother...

10/12/07 14:11:34 changed by anonymous

Thanks! I did what you suggested and it worked, but now I have a whole new problem when it gets to creating the Administration account it spits another parse error at me about unexpected T_ARRAY and expecting & or T_VARIABLE at line 65 of Security.php

Any ideas for how to get past this one?

10/14/07 07:03:44 changed by benoitg

  • status changed from new to closed.
  • resolution set to fixed.

Manually changing the schema version in wifidog-postgres-initial-data.sql is definitely a BIG no-no. Wifidog will think your db is at schema version 57, and eventually try to apply schema update 58, 59, etc on top of it thinking you are at 57, while the schema really was at 56, which WILL hose your database in the long run. So restart with a new database.

Your actual problem is completely unrelated anyway. Security.php Used a PHP 5.1+ feature. This was corrected in r1301

Add/Change #393 (DB schema problems)




Action