There appears to be an error with the database.

October 21, 2013

ok I have nexu installed and I created a group now when I click on my group thsi appears

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again. You can try to refresh the page by clicking here

I repaired the database from my cpanel but nothing any help please

Oturo · October 21, 2013

Click the logs tab in the acp and click mysql errors and you will find it there and paste here the error

Edited October 21, 2013 by Oturo

October 21, 2013

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 04:45:44 +0000
Error: 1064 - 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 '' at line 1
IP Address: 112.111.34.92 - /index.php?app=core&module=global&section=reputation&do=add_rating&app_rate=forums&type=pid&type_id=206147&rating=1&secure_key=cae4f96225cbab736b01b3bc85ae6136&post_return=206147
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: UPDATE profile_portal SET pp_reputation_points=1 WHERE pp_member_id=
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/class_reputation_cache.php | [db_main_mysql].update | 357 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/reputation.php | [classReputationCache].addRate | 75 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/reputation.php | [public_core_global_reputation].doRating | 40 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_core_global_reputation].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 04:45:48 +0000
Error: 1064 - 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 '' at line 1
IP Address: 112.111.34.92 - /index.php?app=core&module=global&section=reputation&do=add_rating&app_rate=forums&type=pid&type_id=206147&rating=-1&secure_key=cae4f96225cbab736b01b3bc85ae6136&post_return=206147
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: UPDATE profile_portal SET pp_reputation_points=-1 WHERE pp_member_id=
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/class_reputation_cache.php | [db_main_mysql].update | 357 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/reputation.php | [classReputationCache].addRate | 75 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/reputation.php | [public_core_global_reputation].doRating | 40 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_core_global_reputation].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 04:45:53 +0000
Error: 1064 - 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 '' at line 1
IP Address: 112.111.34.92 - /index.php?app=core&module=global&section=reputation&do=add_rating&app_rate=forums&type=pid&type_id=206147&rating=1&secure_key=cae4f96225cbab736b01b3bc85ae6136&post_return=206147
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: UPDATE profile_portal SET pp_reputation_points=1 WHERE pp_member_id=
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/class_reputation_cache.php | [db_main_mysql].update | 357 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/reputation.php | [classReputationCache].addRate | 75 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/global/reputation.php | [public_core_global_reputation].doRating | 40 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_core_global_reputation].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 11:06:29 +0000
Error: 1064 - 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 ')' at line 3
IP Address: 46.11.16.95 - /index.php/store/category/3-advertise/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as count
FROM nexus_packages
WHERE p_store=1 AND ( ( FIND_IN_SET(38,p_member_groups) OR FIND_IN_SET(26,p_member_groups) ) OR ( p_member_groups='*' ) ) AND p_group IN( )
;
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/nexus/modules_public/payments/store.php | [public_nexus_payments_store].viewStore | 104 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_nexus_payments_store].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 11:08:48 +0000
Error: 1064 - 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 ')' at line 3
IP Address: 46.11.16.95 - /index.php/store/category/3-advertise/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as count
FROM nexus_packages
WHERE p_store=1 AND ( ( FIND_IN_SET(38,p_member_groups) OR FIND_IN_SET(26,p_member_groups) ) OR ( p_member_groups='*' ) ) AND p_group IN( )
;
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/nexus/modules_public/payments/store.php | [public_nexus_payments_store].viewStore | 104 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_nexus_payments_store].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 11:09:59 +0000
Error: 1064 - 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 ')' at line 3
IP Address: 46.11.16.95 - /index.php/store/category/3-advertise/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as count
FROM nexus_packages
WHERE p_store=1 AND ( ( FIND_IN_SET(38,p_member_groups) OR FIND_IN_SET(26,p_member_groups) ) OR ( p_member_groups='*' ) ) AND p_group IN( )
;
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/nexus/modules_public/payments/store.php | [public_nexus_payments_store].viewStore | 104 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_nexus_payments_store].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 11:11:15 +0000
Error: 1064 - 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 ')' at line 3
IP Address: 46.11.16.95 - /index.php/store/category/3-advertise/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as count
FROM nexus_packages
WHERE p_store=1 AND ( ( FIND_IN_SET(38,p_member_groups) OR FIND_IN_SET(26,p_member_groups) ) OR ( p_member_groups='*' ) ) AND p_group IN( )
;
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/nexus/modules_public/payments/store.php | [public_nexus_payments_store].viewStore | 104 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_nexus_payments_store].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 21 Oct 2013 11:36:27 +0000
Error: 1064 - 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 ')' at line 3
IP Address: 92.80.253.20 - /index.php/store/category/3-advertise/
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT count(*) as count
FROM nexus_packages
WHERE p_store=1 AND ( ( FIND_IN_SET(2,p_member_groups) ) OR ( p_member_groups='*' ) ) AND p_group IN( )
;
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/nexus/modules_public/payments/store.php | [public_nexus_payments_store].viewStore | 104 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_nexus_payments_store].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Edited October 21, 2013 by Verified
Placed in a spoiler as it was breaking the page.

Oturo · October 21, 2013

admin/sources/classes/class_reputation_cache.php

Update:

$member_id = $content_author['id'];

To:

$member_id = intval($content_author['id']);

Line 290

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Edited October 21, 2013 by Oturo

October 21, 2013

Still nothing

Verified · October 21, 2013

Still nothing

Where did you get the download of IP.Nexus from?

October 21, 2013

from here

Lock Down · October 21, 2013

Did you change the permissions so guest can use or not use nexus? There is no member id error in the first error which could mean a guest or a bad nexus record.

So check the permissions and if that is not it try to remove and reinstall nexus. Be sure it is the correct version for your IPB.

October 24, 2013

May have to talk to the WebHost.

They can help.

October 25, 2013

I unisalled nexus and installed it again and it show me this

IP.Board Set Up Utility

Welcome to the IP.Board application set up utility.
This installation is in progress...

The following errors have been found:

· ALTER TABLE members ADD cm_credits FLOAT NOT NULL DEFAULT 0.0;

Duplicate column name 'cm_credits'

Click here to continue regardless

Lock Down · October 25, 2013

Just Click here to continue regardless

Krönik Karbon · October 26, 2013

I have this same issue, exactly the same.

Same package, same problem.

THIS IS THE PRPBLEM:

Problem stems from

admin/applications_addon/ips/nexus/sql/mysql_nexus_queries.php

@ line 33

WHERE (".$a["extra"].") returns ( ) <- should NOT be empty

case self::VIEW_CAT:            {                return '' . "SELECT count(*) as countFROM " . $this->tbl . "nexus_packagesWHERE " . $baseWhere . " AND p_group IN( " . $a["extra"] . " );";            }

SOLUTION:

Change

$a["extra"]

to

$a["type"]

Voila, PROBLEM SOLVED

Edited October 26, 2013 by Krönik Karbon

Verified · October 26, 2013

The question(s) in this support topic have been answered and the owner has been able to solve the problem. Because of this, the support topic has been closed and moved.If you have other questions, please open a new topic.

Advertisement

There appears to be an error with the database.

Question

Guest chaos

Link to comment

Share on other sites

12 answers to this question

Recommended Posts

Link to comment

Share on other sites

Guest chaos

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest chaos

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest chaos

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest AhaAlliance

Link to comment

Share on other sites

Guest chaos

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites