Word Press + Upgrad...
 
Notifications
Clear all

Word Press + Upgrade to 2.0.6 errorrsss

9 Posts
2 Users
0 Reactions
889 Views
 joki
(@joki)
Posts: 29
Eminent Member
Topic starter
 

Hi again, I've upgraded to 2.0.6 and I've got issues again lol..

 

1) Is it sensible to have WordPress sql & combu sql in one database?

 

2) - Indexes for table `CB_ServerSettings` -- ALTER TABLE `CB_ServerSettings` ADD PRIMARY KEY (`DataKey`), ADD UNIQUE KEY `DataKey_UNIQUE` (`DataKey`);

 MySQL said: Documentation#1068 - Multiple primary key defined

 

3) I can create account using combu but get this error every time I try and use CombuDemoWordpress: "Connection to WP not established."

 

I've spent 3+ hours figuring out what to do but I have no idea..

 
Posted : 20/07/2015 11:39 am
(@skaredcreations)
Posts: 806
Prominent Member Admin
 

Download the fixed file combu_db from here and delete your current tables. You can perfectly have both Wordpress and Combu on one database, that's the reason why we have "CB_" as prefix of both tables and classes.

About your issue on WP it means that the connection to Wordpress database is not working, did you edit the file /extra/login_wordpress.php and set the proper connection settings in the defines?

FRANCESCO CROCETTI @ SKARED CREATIONS

 
Posted : 20/07/2015 12:14 pm
 joki
(@joki)
Posts: 29
Eminent Member
Topic starter
 

Thanks a lot, with the new db it goes into 

500

Internal Server Error

 

And for the WP issue now it says 500 internal server error... as well

 
Posted : 20/07/2015 1:00 pm
 joki
(@joki)
Posts: 29
Eminent Member
Topic starter
 

yes I edited /extra/login_wordpress.php. If i type incorrect username then it says invalid credentials or something but when i type the correct user and password it throws "500 internal server error" inside unity.

 
Posted : 20/07/2015 1:03 pm
(@skaredcreations)
Posts: 806
Prominent Member Admin
 

You need also to set the proper relative path to the file wp-load.php that is in the root of Wordpress at line 13, sorry but this wasn't meant to be a documented feature because it's there only as example for those users who are experienced with Wordpress, I'm not a WP programmer but uses only the direct access to wp_users table and call the WP API function wp_check_password to compare.

I suggest these changes, since they will be by default in the next update:

define ("WORDPRESS_SERVER", "localhost");
define ("WORDPRESS_NAME", "wordpress");
define ("WORDPRESS_USERNAME", "root");
define ("WORDPRESS_PASSWORD", "");
define ("WORDPRESS_ROOT", "../../../wp/");

include '../lib/api.php';
include WORDPRESS_ROOT . 'wp-load.php';

FRANCESCO CROCETTI @ SKARED CREATIONS

 
Posted : 20/07/2015 1:11 pm
 joki
(@joki)
Posts: 29
Eminent Member
Topic starter
 

Now it imports the sql fine.. I literally tried 10 times -.-.. So I just got the WP leftthrowing that "500 Internal Server Error" if the login is correct. 

 
Posted : 20/07/2015 1:14 pm
 joki
(@joki)
Posts: 29
Eminent Member
Topic starter
 

Ok I'll look at it now. I didnt see that reply

 
Posted : 20/07/2015 1:15 pm
 joki
(@joki)
Posts: 29
Eminent Member
Topic starter
 

Ok I have wordpress installed at root its not in a sub folder, so is this correct =

define ("WORDPRESS_SERVER", "******");
define ("WORDPRESS_NAME", "
");
define ("WORDPRESS_USERNAME", "
*");
define ("WORDPRESS_PASSWORD", "**********");

define ("WORDPRESS_ROOT", "/");

include '../lib/api.php';
include '../../../wp/wp-load.php';
include WORDPRESS_ROOT . 'wp-load.php';

 

if you don't know thats ok. I'll just have to live without the fix for now. I'l spend a couple of days googling it, and once i find out I will post it here.

 
Posted : 20/07/2015 1:22 pm
(@skaredcreations)
Posts: 806
Prominent Member Admin
 

Not sure you should use "/" since it could mean absolute but just try it out. Otherwise there's nothing difficult, just add "../" for every folder up in your tree starting from "extra".

Anyway in your code above, you must delete the first include of "wp-load.php" (that right after the include of api.php), you only need your second one: include WORDPRESS_ROOT . 'wp-load.php';

FRANCESCO CROCETTI @ SKARED CREATIONS

 
Posted : 20/07/2015 1:27 pm
Share: