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: #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..
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
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
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.
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_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
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.
Ok I'll look at it now. I didnt see that reply
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.
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