FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » db_version missing with upgrade for 3.0.3rc1
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
db_version missing with upgrade for 3.0.3rc1 [message #165760] Mon, 08 August 2011 01:04 Go to next message
djzort is currently offline  djzort   
Messages: 30
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
when i point my browser at upgrade.php, i get this message

Fatal error: Call to undefined function db_version() in /var/www/sites/forum.bong.com.au/htdocs/upgrade.php on line 608

apache is 2.2.16
php is 5.3.3
mysql is 5.1.49
Re: db_version missing with upgrade for 3.0.3rc1 [message #165761 is a reply to message #165760] Mon, 08 August 2011 01:08 Go to previous messageGo to next message
djzort is currently offline  djzort   
Messages: 30
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
this function in the code sets a value, so i manually set it to '5.1.49' and things proceeded, but another error occurred.


Beginning SQL Upgrades.
Checking if SQL permissions to perform the upgrade are available.
Alter database column salt in table fud26_users.
Alter database column avatar_loc in table fud26_users.
Alter database column time_zone in table fud26_users.
Add new database column birthday to table fud26_users.
About to change birthday format. This may take a while...
Birthday format change completed.
Alter database column conf_key in table fud26_users.
Add new database column custom_fields to table fud26_users.
Drop unused database column bday from table fud26_users.
Add new database index fud26_users_i_bd to table fud26_users(birthday).
Add new database column ip_addr to table fud26_ses.
Add new database column useragent to table fud26_ses.
Alter database column ip_addr in table fud26_msg.
Recreate database index fud26_msg_report_i_mu on table fud26_msg_report(msg_id,user_id).
Alter database column location in table fud26_attach.
Add new database column event_day to table fud26_calendar.
Add new database column event_month to table fud26_calendar.
Add new database column event_year to table fud26_calendar.
Drop unused database column day from table fud26_calendar.
Drop unused database column month from table fud26_calendar.
Drop unused database column year from table fud26_calendar.
Add new database index fud26_calendar_i_ymd to table fud26_calendar(event_year,event_month,event_day).
Create new database table /var/www/sites/forum.bong.com.au/FUDforumdata//sql/fud_plugins.tbl.
Add new database column parent to table fud26_forum.
Create new database table /var/www/sites/forum.bong.com.au/FUDforumdata//sql/fud_pages.tbl.
Add new database column votes to table fud26_poll_opt.
Drop unused database column count from table fud26_poll_opt.
Add new database column ann_opt to table fud26_announce.
Drop unused database column id from table fud26_bookmarks.
Drop unused database index fud26_bookmarks_i_u from table fud26_bookmarks.
Create composite primary key on fud26_bookmarks(user_id,thread_id).
Alter database column ip_addr in table fud26_pmsg.
Create new database table /var/www/sites/forum.bong.com.au/FUDforumdata//sql/fud_spiders.tbl.
Create new database table /var/www/sites/forum.bong.com.au/FUDforumdata//sql/fud_jobs.tbl.
Create new database table /var/www/sites/forum.bong.com.au/FUDforumdata//sql/fud_custom_fields.tbl.
Alter database column mbox_user in table fud26_mlist.
Add new database column fixed_from_address to table fud26_mlist.
Drop unused database column id from table fud26_index.
Drop unused database index fud26_index_i_wm from table fud26_index.
Create composite primary key on fud26_index(word_id,msg_id).
Drop unused database index fud26_search_cache_i_sq from table fud26_search_cache.
Create composite primary key on fud26_search_cache(srch_query,query_type,msg_id).
Alter database column ips in table fud26_geoip.
Alter database column ipe in table fud26_geoip.
Drop unused database index fud26_geoip_ip from table fud26_geoip.
Create composite primary key on fud26_geoip(ips,ipe).
Drop unused database index fud26_ann_forums_i_fa from table fud26_ann_forums.
Create composite primary key on fud26_ann_forums(ann_id,forum_id).
Drop unused database column id from table fud26_thread_notify.
Drop unused database index fud26_thread_notify_i_ut from table fud26_thread_notify.
Create composite primary key on fud26_thread_notify(user_id,thread_id).
Recreate database index fud26_mime_f on table fud26_mime(fl_ext).
Drop unused database column id from table fud26_forum_notify.
Drop unused database index fud26_forum_notify_i_uf from table fud26_forum_notify.
Create composite primary key on fud26_forum_notify(user_id,forum_id).
Add new database column ip_addr to table fud26_poll_opt_track.
Drop unused database column id from table fud26_title_index.
Drop unused database index fud26_title_index_i_wm from table fud26_title_index.
Create composite primary key on fud26_title_index(word_id,msg_id).
SQL Upgrades Complete.

Fatal error: Call to undefined function q_limit() in /var/www/sites/forum.bong.com.au/htdocs/upgrade.php on line 954
Re: db_version missing with upgrade for 3.0.3rc1 [message #165762 is a reply to message #165761] Mon, 08 August 2011 01:14 Go to previous messageGo to next message
djzort is currently offline  djzort   
Messages: 30
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
i cant see q_limit used elsewhere in upgrade.php, nor can i find it in the php references. that said, i dont spend much time tinkering with php or the internals of fud_forum
Re: db_version missing with upgrade for 3.0.3rc1 [message #165763 is a reply to message #165762] Mon, 08 August 2011 01:24 Go to previous messageGo to next message
djzort is currently offline  djzort   
Messages: 30
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
ok both these functions are defined in sql/ - i dont know why they arent being brought in. it could be something in my configuration.
Re: db_version missing with upgrade for 3.0.3rc1 [message #165764 is a reply to message #165763] Mon, 08 August 2011 08:16 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3542
Registered: December 2004
Karma: 8
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Strange. File sql/$DBHOST_DBTYPE/db.inc is included on line 587.

From what version are you upgrading?
What is your $DBHOST_DBTYPE in GLOBALS.php?
Re: db_version missing with upgrade for 3.0.3rc1 [message #165790 is a reply to message #165764] Thu, 11 August 2011 06:54 Go to previous messageGo to next message
djzort is currently offline  djzort   
Messages: 30
Registered: May 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
$DBHOST_DBTYPE = 'mysql'

i static set the mysql version and coded out the q_limit function, so my upgrade completed. so im out of the woods, but that wont help other people
Re: db_version missing with upgrade for 3.0.3rc1 [message #165800 is a reply to message #165790] Fri, 12 August 2011 07:26 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3542
Registered: December 2004
Karma: 8
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
And from what version of FUDforum are you upgrading from? I need to know so I can try to reproduce the problem.
Re: db_version missing with upgrade for 3.0.3rc1 [message #165846 is a reply to message #165760] Wed, 17 August 2011 04:41 Go to previous message
seniyajw is currently offline  seniyajw
Messages: 3
Registered: August 2011
Location: Manhattan
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

What brought me back was that when you catch a slow control consistency, the Forum looked ok, but it shows no messages - has shown that the search engine for each format, but no actual post. But perhaps all back, when the consistency check is ready for ...
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Can't post to previously functional forum
Next Topic: Backup/restore fails 3.0.3RC1 (FIXED)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 25 04:57:54 EDT 2014

Total time taken to generate the page: 0.00900 seconds