The solution (in case anyone else has a similar problem) is to run the following commands in phpmyadmin
ALTER TABLE `#__pollsxt_questions` ADD INDEX ( `pollid` ); ALTER TABLE `#__pollsxt_options` ADD INDEX ( `quid` ); ALTER TABLE `#__pollxt_data` ADD INDEX ( `optid` );
Thanks Wolverine - it was a user who was in Joomla but not in SMF and there was a conflict. The url gave me the username and when i deleted him from Joomla and tried to sync all worked fine.
I am getting the following message when trying to sync users ... any ideas ?
Joomla/Mambo[0] / SMF[0] inserted Failed : : _JSMF_MSG_FAILED : 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 \
We installed POLLXT on our site as a more powerful alternative to the core poll component and it has been working well for many months until one day last week when all of a sudden the poll that had been running (without errors) for a week started displaying an error on both the module and also on the poll page .... this is the error
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT d.* n FROM jos_pollsxt_questions AS q n LEFT JOIN jos_pollsxt_options AS o ON o.quid = q.id n LEFT JOIN jos_pollxt_data AS d ON d.optid = o.id n WHERE q.pollid ="35" AND d.user = "*****"ORDER BY d.datu DESC n LIMIT 1
(only thing I changed in the code here was the username at the end where i added *****)
The component was not the most up to date one, so i used online upgrade to upgrade it to 1.22.13 which also displays the same error. V1.30 beta also has the same problem.
From a quick search of google, I am assuming this is an SQL problem rather than a component problem but could definitely do with some help. Google results point to a problem with the max_join_size value but looking at this value with phpmyadmin shows it to be 7000000 so that cant be it.
PHOTOGALLERY: We have used both GALLERY2 and COPPERMINE for our sites. Gallery 2 is on our current live site but is a little slow so on our new site we will be using COPPERMINE which integrates well with Joomla. I believe ZOOM also integrates well with both Joomla and Community Builder (if used) but we havent used it so I cant say for sure.
FORUM: I would recommend SMF instead of PHPBB. We used PHPBB before but had a fair number of issues keeping it integrated with Joomla and had a hard time getting support with our specific issues. The integration may have improved now but SMF (using the bridge from this site instead of the 'official' bridge) is still our forum of choice, not least because questions asked in the forums here are usually answered pretty quickly.
EVENTS: SMF has an inbuilt calendar that will do exactly what you want or you could install EXTCALENDAR component in Joomla which is more powerful.
MAILING LIST: There are so many of these for Joomla that its hard to count. We dont have newsletters/mailings on our current site but will be adding it to the new site we have in development. We narrowed it down to two choices. LETTERMAN which is good for basic newsletters and mailings and ACAJOOM which can handle multiple newsletters. We decided on ACAJOOM as it meets our requirements a bit better.
But wolverine himself wrote that he wanted me to do something, and he would take a look at it.. but he hasn't and you know..
He may not be answering, but I am sure he is listening
Think quite a few of us have different issues where we have asked for his help and many of those issues will no doubt be solved in the next release. be patient
the best way for me to make sure these work is for you to give me user access to your site so I can see them breaking. You can pm me this information if you like.
Yes - Google MemberMap is a mod that can be downloaded from the Simple Machines site and although it is not advertised as being 1.3 compatible, it does install if you amend the file names for the xml. It works in unwrapped mode but doesnt when wrapped - exactly the same behaviour as it displayed with the previous version of the bridge. Mod location : http://mods.simplemachines.org/index.php?mod=241
I also have another mod installed called 'IGNORE' that allows users to ignore other users. It works great and doesnt cause me any problems except when users are modifying their profile - when they go to 'ignore user options' it breaks out of the wrapper - any ideas how to prevent this ? Mod location : http://mods.simplemachines.org/index.php?mod=185
Quote
The account activated message should have only occurred in 1.1.X versions of the bridge.
My mistake - the error is not appearing on my test site which is using V2 but is appearing on my live site which is still using V1.1 - can live with it until I upgrade on live site.
MINOR issues I am having with the current JSMF (or maybe its Joomla) are as follows. fixes or advice would be most appreciated.
GOOGLE MEMBER MAP - I have google member map v0.55 installed and when viewing it unwrapped (http://<mydomain>/<SMF folder>/index.php?action=googlemap) the pins, sidebar and the legend all appear but when viewing it wrapped (http://<mydomain>/index.php?option=com_smf&Itemid=303&action=googlemap), ie. using the bridge, I get the map but no pins and an empty sidebar.
DISAPPEARING MENU OPTIONS - If I have been viewing the site previously and go elsewhere or close browser and then come back, the login module (SMF login) shows me as logged in but the joomla menu shows only those items available to guests. When I click on any of the links (eg click HOME or FORUM) I go to the relevant page and my full menu appears. Something somewhere is not telling joomla I am logged in ??
SMF MESSAGES OR UDDEIM ? - I have set the site to use UDDEIM for messaging and the links in the forum or on the tab list all get redirected to UDDEIM. However, when a user is modifying their profile the PERSONAL MESSAGE OPTIONS still point to SMF messaging.
USER SYNCHRONISING - Mentioned this one before but as I am adding all my little problems in one place, thought I would add it again. When accessing forum admin it breaks out of the wrapped mode and into unwrapped mode and therefore out of the bridge. If I make adjustments to the member list the sync with joomla doesnt work and I have ended up having to try and make sure i delete users from both separately and never knowing if it has worked. On the odd occasion that the admin section DOES load in wrapped mode, when clicking on the activation tab to look at new members and decide whether to email them, delete them, approve them etc, I get a message that says your account has been activated and it goes back to forum index.
As I said at the top - help and advice greatly appreciated
Wolverine - excellent work as usual and it has solved a few of the problems I was having but I am still having a couple of issues - maybe they are my issues, or Joomla issues or maybe they are the bridge, I dont know.
1. When logged in as admin and viewing the forum in wrapped mode, I click on the SMF ADMIN link (<site>/index.php?option=com_smf&Itemid=299&action=admin) and that address always seems to take me to the password page which is unwrapped. (Previously I only got this on my first visit to admin area, subsequent visits brought admin area up wrapped inside joomla).
Bearing in mind that you mentioned there were issues regarding the integration of the bridge with joomla or the syncing of info between them if the forum is unwrapped this gives me a problem as I cant get it to load. After entering my password, the page that loads has the address <site>/<forum dir>/index.php?option=com_smf;Itemid=299;action=admin. If I manually remove the forum directory portion of the address Joomla tells me the page does not exist.
2. If I try to sync by username in the admin or 'verify', I get the same inserted / failed message (see screenshots) and the main component config changes back to show that 'synchronise' usernames is disabled
Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved. Terms of Use
Show Posts
Forum
