XF 2.0 LogicException: xf_css_cache already exists,

[Mr Lucky]

I'm getting this as soon as I start the upgrade:

LogicException: xf_css_cache already exists, but the structure does not match. in src/XF/Db/Schema/Create.php at line 51
XF\Db\Schema\Create->getQuery() in src/XF/Db/Schema/AbstractDdl.php at line 132
XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 171
XF\Db\SchemaManager->createTable() in src/XF/Install/Upgrade/2000010-200a.php at line 121
XF\Install\Upgrade\Version2000010->step2() in src/XF/Install/Controller/Upgrade.php at line 152
XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 232
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 85
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1771
XF\App->run() in src/XF.php at line 319
XF::runApp() in install/index.php at line 14

 

[Chris D]

Is this your first attempt at running the upgrade or did a previous attempt fail with a different error?

Are you able to perform a MySQL query? If so, can you report back the results of:

SHOW COLUMNS FROM xf_css_cache

 

[Mr Lucky]

First go at upgrading.

Field     Type     Null     Key     Default     Extra     
cache_id     int(10) unsigned     NO     PRI     NULL    auto_increment
style_id     int(10) unsigned     NO     MUL     NULL   
language_id     int(10) unsigned     NO         NULL   
title     varbinary(150)     NO         NULL   
modifier_key     varbinary(32)     NO         NULL   
output     mediumblob     NO         NULL   
cache_date     int(10) unsigned     NO         NULL

 

[Mike]

What MySQL version are you using?

 

[Mr Lucky]

10.1.26-MariaDB

 

[Raju Choudhary]

Hi i am going to upgrade my forum but i get following error

LogicException: xf_upgrade_job already exists, but the structure does not match. in src/XF/Db/Schema/Create.php at line 51

1. XF\Db\Schema\Create->getQuery() in src/XF/Db/Schema/AbstractDdl.php at line 132
2. XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 171
3. XF\Db\SchemaManager->createTable() in src/XF/Install/Upgrade/2000010-200a.php at line 415
4. XF\Install\Upgrade\Version2000010->step3() in src/XF/Install/Controller/Upgrade.php at line 152
5. XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 232
6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 85
7. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
8. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1771
9. XF\App->run() in src/XF.php at line 319
10. XF::runApp() in install/index.php at line 14

Please check http://forum.caknowledge.in/

 

[Mr Lucky]

Any news on what might be causing this ?

 

[Mike]

Technically, this error is erroneous (heh), so we have fixed that. (The structure is what we expect.)

But we haven't necessarily identified what would have caused this in the first place, which is the step running multiple times. At the least, you'll need to wait until beta 2 to try an upgrade again.

 

[Mr Lucky]

this error is erroneous (heh), so we have fixed that. (The structure is what we expect.)

Thanks

At the least, you'll need to wait until beta 2 to try an upgrade again.

 

[Mr Lucky]

Technically, this error is erroneous (heh), so we have fixed that. (The structure is what we expect.)

But we haven't necessarily identified what would have caused this in the first place, which is the step running multiple times. At the least, you'll need to wait until beta 2 to try an upgrade again.

No, tried again with beta 2 and same error

 

[Mike]

What version of PHP are you using?

Can you look at your PHP info and report all of the info from the mysqli section and, if present, the mysqlnd section?

 

[Mr Lucky]

What version of PHP are you using?

Can you look at your PHP info and report all of the info from the mysqli section and, if present, the mysqlnd section?

It's php 7.1. Sorry, I'm not sure what mysqli section means. My host @MattW may be able to give more info.

 

[MattW]

You get that from the phpinfo page which you can get from the ACP of your site.

 

[MattW]

admin.php?tools/phpinfo

Also, you are using PHP 7.0.23

 

[Mr Lucky]

admin.php?tools/phpinfo

Thanks Matt

Also, you are using PHP 7.0.23

The xf1 live forum (I am sporting database from) is php 7.0, the xf2 forum (importing database into) is 7.1
Maybe that is causing the issue, I will switch the xf2 to 7.0

Or would it be better if they were both 7.1?

 

[MattW]

Shouldn't really make a difference as far as I know, as I've built 7 and 7.1 with all the same modules.

 

[Mr Lucky]

What version of PHP are you using?

Can you look at your PHP info and report all of the info from the mysqli section and, if present, the mysqlnd section?

Hope this helps:

MysqlI Support    enabled
Client API library version    mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
Active Persistent Links    0
Inactive Persistent Links    0
Active Links    1

Directive    Local Value    Master Value
mysqli.allow_local_infile    On    On
mysqli.allow_persistent    On    On
mysqli.default_host    no value    no value
mysqli.default_port    3306    3306
mysqli.default_pw    no value    no value
mysqli.default_socket    /var/lib/mysql/mysql.sock    /var/lib/mysql/mysql.sock
mysqli.default_user    no value    no value
mysqli.max_links    Unlimited    Unlimited
mysqli.max_persistent    Unlimited    Unlimited
mysqli.reconnect    Off    Off
mysqli.rollback_on_cached_plink    Off    Off

mysqlnd    enabled
Version    mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
Compression    supported
core SSL    supported
extended SSL    supported
Command buffer size    4096
Read buffer size    32768
Read timeout    31536000
Collecting statistics    Yes
Collecting memory statistics    No
Tracing    n/a
Loaded plugins    mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password
API Extensions    mysqli,pdo_mysql

mysqlnd statistics   
bytes_sent    7682
bytes_received    419561
packets_sent    182
packets_received    1079
protocol_overhead_in    4316
protocol_overhead_out    728
bytes_received_ok_packet    0
bytes_received_eof_packet    0
bytes_received_rset_header_packet    576
bytes_received_rset_field_meta_packet    0
bytes_received_rset_row_packet    201
bytes_received_prepare_response_packet    52700
bytes_received_change_user_packet    365273
packets_sent_command    89
packets_received_ok    0
packets_received_eof    0
packets_received_rset_header    64
packets_received_rset_field_meta    0
packets_received_rset_row    30
packets_received_prepare_response    686
packets_received_change_user    262
result_set_queries    22
non_result_set_queries    8
no_index_used    2
bad_index_used    0
slow_queries    0
buffered_sets    0
unbuffered_sets    0
ps_buffered_sets    22
ps_unbuffered_sets    0
flushed_normal_sets    0
flushed_ps_sets    0
ps_prepared_never_executed    0
ps_prepared_once_executed    25
rows_fetched_from_server_normal    0
rows_fetched_from_server_ps    240
rows_buffered_from_client_normal    0
rows_buffered_from_client_ps    240
rows_fetched_from_client_normal_buffered    0
rows_fetched_from_client_normal_unbuffered    0
rows_fetched_from_client_ps_buffered    240
rows_fetched_from_client_ps_unbuffered    0
rows_fetched_from_client_ps_cursor    0
rows_affected_normal    0
rows_affected_ps    0
rows_skipped_normal    0
rows_skipped_ps    240
copy_on_write_saved    0
copy_on_write_performed    0
command_buffer_too_small    0
connect_success    2
connect_failure    0
connection_reused    0
reconnect    0
pconnect_success    2
active_connections    0
active_persistent_connections    0
explicit_close    1
implicit_close    0
disconnect_close    0
in_middle_of_command_close    0
explicit_free_result    45
implicit_free_result    1
explicit_stmt_close    24
implicit_stmt_close    1
mem_emalloc_count    0
mem_emalloc_amount    0
mem_ecalloc_count    0
mem_ecalloc_amount    0
mem_erealloc_count    0
mem_erealloc_amount    0
mem_efree_count    0
mem_efree_amount    0
mem_malloc_count    0
mem_malloc_amount    0
mem_calloc_count    0
mem_calloc_amount    0
mem_realloc_count    0
mem_realloc_amount    0
mem_free_count    0
mem_free_amount    0
mem_estrndup_count    0
mem_strndup_count    0
mem_estndup_count    0
mem_strdup_count    0
proto_text_fetched_null    0
proto_text_fetched_bit    0
proto_text_fetched_tinyint    0
proto_text_fetched_short    0
proto_text_fetched_int24    0
proto_text_fetched_int    0
proto_text_fetched_bigint    0
proto_text_fetched_decimal    0
proto_text_fetched_float    0
proto_text_fetched_double    0
proto_text_fetched_date    0
proto_text_fetched_year    0
proto_text_fetched_time    0
proto_text_fetched_datetime    0
proto_text_fetched_timestamp    0
proto_text_fetched_string    0
proto_text_fetched_blob    0
proto_text_fetched_enum    0
proto_text_fetched_set    0
proto_text_fetched_geometry    0
proto_text_fetched_other    0
proto_binary_fetched_null    0
proto_binary_fetched_bit    1529
proto_binary_fetched_tinyint    0
proto_binary_fetched_short    398
proto_binary_fetched_int24    19
proto_binary_fetched_int    0
proto_binary_fetched_bigint    283
proto_binary_fetched_decimal    4
proto_binary_fetched_float    0
proto_binary_fetched_double    0
proto_binary_fetched_date    0
proto_binary_fetched_year    0
proto_binary_fetched_time    0
proto_binary_fetched_datetime    0
proto_binary_fetched_timestamp    0
proto_binary_fetched_string    0
proto_binary_fetched_json    1419
proto_binary_fetched_blob    66
proto_binary_fetched_enum    0
proto_binary_fetched_set    0
proto_binary_fetched_geometry    0
proto_binary_fetched_other    0
init_command_executed_count    0
init_command_failed_count    0
com_quit    1
com_init_db    0
com_query    4
com_field_list    0
com_create_db    0
com_drop_db    0
com_refresh    0
com_shutdown    0
com_statistics    0
com_process_info    0
com_connect    0
com_process_kill    0
com_debug    0
com_ping    0
com_time    0
com_delayed_insert    0
com_change_user    0
com_binlog_dump    0
com_table_dump    0
com_connect_out    0
com_register_slave    0
com_stmt_prepare    26
com_stmt_execute    26
com_stmt_send_long_data    0
com_stmt_close    25
com_stmt_reset    7
com_stmt_set_option    0
com_stmt_fetch    0
com_deamon    0
bytes_received_real_data_normal    0
bytes_received_real_data_ps    361867

 

[Mike]

If you can get a setup in position to start an upgrade (1.x DB, 2.x files, upgrade not started), I can do some testing to see if I can resolve the issue.

If that's an option, I'll need FTP details (and ACP access details to start the upgrader). Please submit those via a ticket (referencing this thread).

 

[Mr Lucky]

Thanks MIke

I've been doing some testing and did manage to get it to upgrade, I'm just doing another test to see if I can pinpoint the issue and see how to replicate it.

If I can do that I'll let you know.