mainIgloo; the free Interest group social networking and collaboration platform! - Support: sr #105116, MySQL errors

 
 

sr #105116: MySQL errors

Submitter:  None
Submitted:  Thu 02 Feb 2006 09:55:11 PM UTC
   
 
Category:  None Priority:  5 - Normal
Severity:  4 - Important Status:  None
Privacy:  Public Assigned to:  None
Originator Email:  -email is unavailable- Open/Closed:  Open
Operating System:  GNU/Linux
* Mandatory Fields

Add a New Comment Rich Markup
   

Thu 02 Feb 2006 09:55:11 PM UTC, original submission:  

My Web Host's MySQL database did not accecpt the InnoDB table type, so I changed them all to MyISAM type.  Everything worked all the way through setting up Admin stuff and logging out.  After logging out, I clicked on 'People' and received the following error messages:

Database error.: function=getBlockStatus class=getSocialNetwork.class.php -- SELECT user_id_blocked FROM igloo_user_blocked WHERE user_id_blocker= and user_id_blocked=1 -- 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 'and user_id_blocked=1' at line 4

Database error.: function=getBlockStatus class=getSocialNetwork.class.php -- SELECT user_id_blocked FROM igloo_user_blocked WHERE user_id_blocker= and user_id_blocked=1 -- 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 'and user_id_blocked=1' at line 4

Database error.: function=selRelations class=getSocialNetwork.class.php -- SELECT r.user_id, r.user_id_relation, r.relation_show_network, r.relation_show_true_self FROM igloo_user_relation r, igloo_user u WHERE r.user_id= AND r.user_id_relation!= AND r.user_id_relation=u.user_id AND r.relation_type_id=2 AND u.status_id=4 AND 1=1 order by r.user_id_relation -- 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 'AND r.user_id_relation!= AND r.user_id_relation=u.user

Database error.: function=selRelations class=getSocialNetwork.class.php -- SELECT r.user_id, r.user_id_relation, r.relation_show_network, r.relation_show_true_self FROM igloo_user_relation r, igloo_user u WHERE r.user_id=1 AND r.user_id_relation!= AND r.user_id_relation=u.user_id AND r.relation_type_id=2 AND u.status_id=4 AND 1=1 order by r.user_id_relation -- 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 'AND r.user_id_relation=u.user_id AND r.relation_type_id

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

Only logged-in users can vote.

 

No changes have been made to this item

Back to the top

Powered by Savane 3.13-02a9.
Corresponding source code