View Issue Details

IDProjectCategoryView StatusLast Update
0015599phpList 3 applicationGeneralpublic22-08-18 18:07
Reporterkublermdk Assigned To 
PrioritynormalSeveritytextReproducibilitysometimes
Status newResolutionopen 
PlatformLinuxOSUbuntuOS Version10.4
Product Version2.11.6 
Summary0015599: Database update from 2.10.13 fails
DescriptionURL : http://news.zeitgeistaustralia.org/admin/?page=upgrade&doit=yes

Two database 1109 Errors regarding the table 'phplist_config' which doesn't exist.
Also got a database error 1064.
Steps To ReproduceUpgraded to 2.10.13
Database checked out OK but was getting MySQL select errors when trying to send a message to people with a specific attribute (which State they are from).

Tried updating to 2.11.6, however got the MySQL errors listed in the Additional Information section.
Tried to 'Initialise the database', however that hasn't helped either.
Note that when I run 'Verify the Database structure' there are no errors.
Additional InformationYour database version: 2.10.13

Please wait, upgrading your database, do not interrupt

Database error 1050 while doing query Table 'phplist_linktrack_forward' already exists
Database error 1050 while doing query Table 'phplist_linktrack_ml' already exists
Database error 1050 while doing query Table 'phplist_linktrack_uml_click' already exists
Sorry a software error occurred:
Please report a bug when reporting the bug, please include URL and the entire content of this page.
Notice: Undefined index: lastquery in /var/www/zeitgeistaustralia/news/admin/mysql.inc on line 66 phplist version 2.11.6

Database error 1064 while doing query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-phplist' at line 1
Upgrading the database to use UTF-8, please wait
Upgrading table phplist_admin
Upgrading table phplist_admin_attribute
Upgrading table phplist_adminattribute
Upgrading table phplist_attachment
Upgrading table phplist_bounce
Upgrading table phplist_bounceregex
Upgrading table phplist_config
Upgrading table phplist_eventlog
Upgrading table phplist_linktrack
Upgrading table phplist_linktrack_userclick
Upgrading table phplist_list
Upgrading table phplist_listrss
Upgrading table phplist_message
Upgrading table phplist_messagedata
Upgrading table phplist_rssitem
Upgrading table phplist_rssitem_data
Upgrading table phplist_sendprocess
Upgrading table phplist_subscribepage
Upgrading table phplist_subscribepage_data
Upgrading table phplist_task
Upgrading table phplist_template
Upgrading table phplist_templateimage
Upgrading table phplist_urlcache
Upgrading table phplist_user_attribute
Upgrading table phplist_user_blacklist
Upgrading table phplist_user_blacklist_data
Upgrading table phplist_user_message_forward
Upgrading table phplist_user_user
Upgrading table phplist_user_user_attribute
Upgrading table phplist_user_user_history
Upgrading table phplist_usermessage
Upgrading table phplist_userstats
Upgrading column loginname
Upgrading column namelc
Upgrading column email
Upgrading column modifiedby
Upgrading column password
Upgrading column value
Upgrading column name
Upgrading column type
Upgrading column default_value
Upgrading column tablename
Upgrading column filename
Upgrading column remotefile
Upgrading column mimetype
Upgrading column description
Upgrading column header
Upgrading column status
Upgrading column comment
Upgrading column regex
Upgrading column action
Upgrading column comment
Upgrading column status
Upgrading column item
Upgrading column value
Upgrading column type
Upgrading column page
Upgrading column entry
Upgrading column url
Upgrading column forward
Upgrading column name
Upgrading column data
Upgrading column name
Upgrading column description
Upgrading column prefix
Upgrading column rssfeed
Upgrading column category
Upgrading column type
Upgrading column info
Upgrading column subject
Upgrading column fromfield
Upgrading column tofield
Upgrading column replyto
Upgrading column message
Upgrading column textmessage
Upgrading column footer
Upgrading column status
Upgrading column userselection
Upgrading column sendformat
Upgrading column rsstemplate
Upgrading column name
Upgrading column data
Upgrading column title
Upgrading column link
Upgrading column source
Upgrading column tag
Upgrading column data
Upgrading column ipaddress
Upgrading column page
Upgrading column title
Upgrading column name
Upgrading column data
Upgrading column page
Upgrading column type
Upgrading column title
Upgrading column mimetype
Upgrading column filename
Upgrading column url
Upgrading column content
Upgrading column name
Upgrading column type
Upgrading column default_value
Upgrading column tablename
Upgrading column email
Upgrading column email
Upgrading column name
Upgrading column data
Upgrading column forward
Upgrading column status
Upgrading column email
Upgrading column uniqid
Upgrading column rssfrequency
Upgrading column password
Upgrading column extradata
Upgrading column foreignkey
Upgrading column value
Upgrading column ip
Upgrading column summary
Upgrading column detail
Upgrading column systeminfo
Upgrading column status
Upgrading column item
upgrade to UTF-8, done
Sorry a software error occurred:
Please report a bug when reporting the bug, please include URL and the entire content of this page.
Notice: Undefined index: lastquery in /var/www/zeitgeistaustralia/news/admin/mysql.inc on line 66 phplist version 2.11.6

Database error 1109 while doing query Unknown table 'phplist_config' in information_schema
Sorry a software error occurred:
Please report a bug when reporting the bug, please include URL and the entire content of this page.
Notice: Undefined index: lastquery in /var/www/zeitgeistaustralia/news/admin/mysql.inc on line 66 phplist version 2.11.6

Database error 1109 while doing query Unknown table 'phplist_config' in information_schema
Tagsdocumentation

Activities

There are no notes attached to this issue.