Resource icon

Threads, posts and conversations per page [Paid] 2.0.8

PayPal: $18.00
Dave Upton Run these queries to fix it.

Code:
ALTER TABLE xf_user_option RENAME COLUMN custom_messages TO dpp_custom_config;

And make a job to migrate data.
Code:
INSERT IGNORE INTO `xf_job`
(unique_key, execute_class, execute_data, manual_execute, trigger_date)
VALUES
('dpp_migrate206', 'Truonglv\DiscussionsPerPage:Migrate206', 'a:0:{}', 0, 0)
 
Dave Upton Run these queries to fix it.

Code:
ALTER TABLE xf_user_option RENAME COLUMN custom_messages TO dpp_custom_config;

And make a job to migrate data.
Code:
INSERT IGNORE INTO `xf_job`
(unique_key, execute_class, execute_data, manual_execute, trigger_date)
VALUES
('dpp_migrate206', 'Truonglv\DiscussionsPerPage:Migrate206', 'a:0:{}', 0, 0)
TruonglvGetting an error but not sure if its the same as what Dave went through.

Here's the error:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'dpp_custom_config' in 'field list' in src/XF/Db/AbstractStatement.php at line 228

  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 326
  6. XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1515
  7. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
  8. XF\Mvc\Entity\Entity->save() in src/XF/Mvc/Entity/Entity.php at line 1260
  9. XF\Mvc\Entity\Entity->save() in src/XF/Mvc/FormAction.php at line 69
  10. XF\Mvc\FormAction->XF\Mvc\{closure}() in src/XF/Mvc/FormAction.php at line 187
  11. XF\Mvc\FormAction->run() in src/XF/Pub/Controller/Account.php at line 380
  12. XF\Pub\Controller\Account->actionPreferences() in src/XF/Mvc/Dispatcher.php at line 350
  13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
  14. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
  15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
  16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
  17. XF\App->run() in src/XF.php at line 488
  18. XF::runApp() in index.php at line 20
 
Getting an error but not sure if its the same as what Dave went through.

Here's the error:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'dpp_custom_config' in 'field list' in src/XF/Db/AbstractStatement.php at line 228

  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 326
  6. XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1515
  7. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
  8. XF\Mvc\Entity\Entity->save() in src/XF/Mvc/Entity/Entity.php at line 1260
  9. XF\Mvc\Entity\Entity->save() in src/XF/Mvc/FormAction.php at line 69
  10. XF\Mvc\FormAction->XF\Mvc\{closure}() in src/XF/Mvc/FormAction.php at line 187
  11. XF\Mvc\FormAction->run() in src/XF/Pub/Controller/Account.php at line 380
  12. XF\Pub\Controller\Account->actionPreferences() in src/XF/Mvc/Dispatcher.php at line 350
  13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
  14. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
  15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
  16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
  17. XF\App->run() in src/XF.php at line 488
  18. XF::runApp() in index.php at line 20
korny30See above message I replied.
 
I don't want to be forced to upgrade to a RC version yet. Please let me download the previous version compatible with XF 2.1

Thanks
 
Truonglv

I guess you haven't seen the reply I sent you in this thread so I will post another one.

Getting an error but not sure if its the same as what Dave went through.

Here's the error:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'dpp_custom_config' in 'field list' in src/XF/Db/AbstractStatement.php at line 228

  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
  3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
  4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
  5. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 326
  6. XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1515
  7. XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
  8. XF\Mvc\Entity\Entity->save() in src/XF/Mvc/Entity/Entity.php at line 1260
  9. XF\Mvc\Entity\Entity->save() in src/XF/Mvc/FormAction.php at line 69
  10. XF\Mvc\FormAction->XF\Mvc\{closure}() in src/XF/Mvc/FormAction.php at line 187
  11. XF\Mvc\FormAction->run() in src/XF/Pub/Controller/Account.php at line 380
  12. XF\Pub\Controller\Account->actionPreferences() in src/XF/Mvc/Dispatcher.php at line 350
  13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
  14. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
  15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
  16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
  17. XF\App->run() in src/XF.php at line 488
  18. XF::runApp() in index.php at line 20
 
Back
Top