Mike,
Hi, I think I found a bug. Simgallery won't let me publish any comments, comments box will show but after writting a comment Simgal kicks me out of my site and asks me to log in again to place a comment. I'm using Joomla 1.5.8, sh404sef but it's disabled for Simgal, CB 1.2 RC 3 and Simgal 1.0.9 I did a clean install and I turned on debug on Joomla, this is what I found: 500 - JDatabaseMySQL::query: 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 SQL=SELECT COUNT ( * ) FROM jos_simgallery_comments WHERE `cmtpic`=
I went to line 213 on /components/com_comprofiler/plugin/user/plug_simgallery/simgallery.php and I found this:
line 212: $_CB_database->setQuery("SELECT COUNT ( * ) FROM #__simgallery_comments WHERE `cmtpic`=$photo->id");
line 213: $comments = $_CB_database->loadResult();
Besides the fact it won't let me publish comments, comments box shows like a regular textbox, no emoticons show on top of it. Please help, as this is an issue many others could face when they upgrade to J 1.5.8 and CB 1.2 RC 3.
Related issues:
http://mike.simbunch.com/Forum/SIMGallery/804-FIXED-Comments-avatar-and-link-/ http://mike.simbunch.com/Forum/SIMGallery/786-User-Avatar-amp-Username/ Any suggestion to fix it please?
Thanks
Alex
P.D. Sorry for the replay.. but something happen with the first topic.
Commercial Projects
