Problems with E107 integration

[Antonio47]

I spend nearly 3 hours but I can't get the integration working with E107 version 0.7.5.

When installing there are some uncertain points regarding URL and paths

1- Regarding the E107 forum path and url, the registration is not via the forum registration form but via (E107) sigup.php file and this file is located in the E107 main directory.

2- Temporarily for the above forum path and url I just included the E107 main directory in my case Community folder (not the forum folder as the forum is E107's plugin)

3- Also indicated the E107 user table in this case e107_user, but when I see the ads main front page I do get the following errors:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/ads/forums/e107.php on line 263

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/ads/forums/e107.php on line 281

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/ads/forums/e107.php on line 62

In all 3 errors there is the forums folder.

Some help is appreciated.

Thanks in advance

[Chuck S]

Make sure for one your inputting the correct url to your forum as thats how it is suppose to be set and it looks to me as far as queries you are not inputting the correct e107 database table prefix look at this query

Content visible to verified customers only.

Therefore looking at the query two things. On initial config screen you need to ensure your entering the proper database for e107 in the user database portion and then on step 4 of install we ask for the mysql table prefix of your e107 tables

You have not entered one of those two correctly hense we can not grab the info needed.

[Antonio47]

Originally Posted by Chuck S

Make sure for one your inputting the correct url to your forum as thats how it is suppose to be set and it looks to me as far as queries you are not inputting the correct e107 database table prefix look at this query

Content visible to verified customers only.

Therefore looking at the query two things. On initial config screen you need to ensure your entering the proper database for e107 in the user database portion and then on step 4 of install we ask for the mysql table prefix of your e107 tables

You have not entered one of those two correctly hense we can not grab the info needed.

I re-installed the script again but still have problems:

What I have included/selected on step 4:

1- Your forum integration: E107 CMS
2- admin email address: webmaster@xxxxxx.net
3- URL to your forum: http://www.xxxxxx.net/community/e107_plugins/forum
This if the forum plugin location for e017
4- Forums database: xxxxxx_aa107
(this is where are located all the tables for E107)
on this section I'm not sure if to include the database for E107 or the
actual E107 user table which is e107_user
5- Forum cookie prefix: blank
6- SMF or WowBB: Blank
7- UBB threads etc: Blank
8- Your website name: Community ads
9- Website url: http://www.xxxxxx.net/community
10- Url to the Photo post classifieds: http://www/xxxx.net/ads

After inserting all this info on the installation on step 4 and press submit soon goes on the page step 5 I do get the following ERRORS:

ERROR Table xxxxxx.aa107.cp_usergroups doesn't exist
ERROR Table xxxxxx.aa107.cp_usergroups doesn't exist
ERROR Table xxxxxx.aa107.cp_usergroups doesn't exist

Warning mysql_fetch_row() etc...........
Warning mysql_num_rows() etc...........

Please where I doing wrong?

[Chuck S]

Your not installing a forum plugin. You list the url to e107 itself

It looks to me like your not inputting the correct database information and without an exact url to see I cant really say more than to check what info your entering for database and prefixes. Every true error you have posted is because your not entering the right database stuff.

example this is your e107 table prefix by default

e107_

[Antonio47]

Originally Posted by Chuck S

Your not installing a forum plugin. You list the url to e107 itself

It looks to me like your not inputting the correct database information and without an exact url to see I cant really say more than to check what info your entering for database and prefixes. Every true error you have posted is because your not entering the right database stuff.

example this is your e107 table prefix by default

e107_

Well at last I found why the installation was not working correctly for the E107 cms option:

1- the bug the in your file forums/E107.php on line 279 with the following code:

$query = "SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,
highlight,bold,italic,payment,uplimit FROM {$Globals['pp_db_prefix']}usergroups WHERE groupid=$groupvalue LIMIT 1";

2- Now when installing the ads the script will create a table named: usergroups

3- If you look on note 1 the query is looking for the {$Globals['pp_db_prefix']} which in this case is = to cp_

4- Therefore the proper table's name should be: cp_usergroups once I renamed the table as indicated the problem was solved.

I assume either the installation file needs an alteration to create the proper name table (for the usergroups) or the E107.php file need the modification on line 279.

[Chuck S]

Line 457 of e107.php

Content visible to verified customers only.

needs to be this

Content visible to verified customers only.

[Antonio47]

Originally Posted by Chuck S

Line 457 of e107.php

Content visible to verified customers only.

needs to be this

Content visible to verified customers only.

More problems:

After editing the line as you above specified, I made a fresh install, during the installation all went fine until we reached the STEP 5.
(at this point created all tables including the cp_usergroups)

On that page on the top there is the following error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/ads/forums/e107.php on line 386
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,0,0)' at line 1
Error: Column count doesn't match value count at row 1.