[#8368] - [3.5-beta1] Databaseproblem
- Closed
- 17 Nov 2015
- Low
- Build: master
- # 8368
Steps to reproduce the issue
after update from 3.4 to 3.5
I open Extensions: Database
and found the Warning that the db is not uptodate
12 Database problems were found:
Database schema version (3.4.0-2015-02-26) does not match CMS version (3.5.0-2015-11-05).
Database update version (3.4.5) does not match CMS version (3.5.0-beta).
Table 'jos_banners' does not have column 'alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_categories' does not have column 'alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_contact_details' does not have column 'alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_content' does not have column 'alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_menu' does not have column 'alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_newsfeeds' does not have column 'alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_tags' does not have column 'alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_ucm_content' does not have column 'core_alias' with type 'varchar(191)'. (From file 3.5.0-2015-07-01.sql.)
Table 'jos_contentitem_tag_map' should not have index 'idx_tag'. (From file 3.5.0-2015-10-26.sql.)
Table 'jos_contentitem_tag_map' should not have index 'idx_type'. (From file 3.5.0-2015-10-26.sql.)
after click on the button fix an 500 internal server error appears
Expected result
fix database
Actual result
500 internal server error
System information (as much as possible)
PHP Built On Windows NT SRV10069 6.1 build 7600 (Windows Server 2008 R2 Enterprise Edition) i586
Database Version 5.1.56-community
Database Collation utf8_general_ci
Database Connection Collation utf8_general_ci
PHP Version 5.6.0
Web Server Microsoft-IIS/7.5
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.5.0-beta Beta [ Ember ] 06-November-2015 24:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Additional comments
test.dancing-dangerous.at if needed a user and pw could be send
| Milestone |
Added: |
||
yes, but info needed
what are the (12) tables structure ?
i use mysql Database Version 5.1.56-community
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8368.
I installed joomla two days ago and the db was autom. installed
is this the information you where looking for?
phpmyadmin:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 1
Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: f373ea5dd5538761406a8022a4b8a374418b240e $
Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off
Could this one here be related to #8267 ?
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8368.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-11-17 10:41:48 |
| Closed_By | ⇒ | roland-d | |
| Rel_Number | 0 | ⇒ | 8267 |
| Relation Type | ⇒ | Duplicate of |
joomla-cms-bot
- 
@akinom500 Thanks for your report, I am going to close it as it is a duplicate of #8267 and we are working to fix this for the next beta release.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/8368.
| Status | Closed | ⇒ | New |
| Closed_Date | 2015-11-17 10:41:48 | ⇒ | |
| Closed_By | roland-d | ⇒ |
| Status | New | ⇒ | Closed |
| Milestone |
Removed: |
||
@joomla-cms-bot please don't reopen issues that gets closed by maintainers thanks 
@alikon can you check it? @akinom500 what databse do you use on the Windows server? MSSQL oder MySQL or other?