I was extremely excited when I read that the integration script generator was added to this latest release.I have it up and running but when I submit the generator fields it takes me to a login screen . I login and try the integration script drop down to select the script I just generated but I dont see any that would be to the one I created. I dont see any members from the other script in the wsn memberlist. SO I know its not integrated yet.
Am I missing a step to this generation? SHould the integration folder have write permissions?
If you have the answer please let me know. This is what I have been waiting for!! thanks.
ok, I tried the integration generator again and this time I changed my integrtion directory to have write permissions first and that worked so that I could choose the correct file from the integration drop down. But now I cannot login and I get this message:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/me/public_html/ee/classes/database.php on line 94
I am going to set the integration off in phpmyadmin but I would like to know how I can make this work. how can I fix the error?
Load time so far: 0.22 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Load time so far: 0.23 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 51 for Resource id #37
Load time so far: 0.24 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #39
Load time so far: 0.24 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #40
Load time so far: 0.25 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.26 seconds. Performing query: SELECT member_id,group_id,weblog_id,tmpl_group_id,upload_id,username,screen_name,password,unique_id,authcode,email,url,location,occupation,interests,bday_d,bday_m,bday_y,aol_im,yahoo_im,msn_im,icq,bio,ip_address,join_date,last_visit,total_entries,total_comments,last_entry_date,last_comment_date,last_email_date,in_authorlist,accept_admin_email,accept_user_email,notify_by_default,language,timezone,daylight_savings,localization_is_site_default,time_format,theme,tracker,template_size,notepad,notepad_size,quick_links,pmember_id,links,comments,ip,totalhits,totalhitsin,template,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel FROM exp_members WHERE member_id=1 AND validated=1 ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/me/public_html/ee/classes/database.php on line 94
Mysql error while fetching row for :Unknown column 'validated' in 'where clause'
Load time so far: 0.27 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Unknown column 'validated' in 'where clause'
Number of rows is 0 for Resource id #49
Load time so far: 0.27 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, exp_members WRITE;
Load time so far: 0.27 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #50
Load time so far: 0.27 seconds. Performing query: UNLOCK TABLES;
Warning: Cannot modify header information - headers already sent by (output started at /home/me/public_html/ee/classes/database.php:276) in /home/me/public_html/ee/end.php on line 143
This was below the login form:
Load time so far: 0.46 seconds. Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1121976747 AND memberid > 0 ;
Number of rows is 0 for Resource id #59
Load time so far: 0.46 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1121976747;
Load time so far: 0.46 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE ip='67.87.179.34' AND memberid=0 ;
Number of rows is 1 for Resource id #60
Load time so far: 0.46 seconds. Performing query: UPDATE wsnlinks_sessions SET time='1121977647', location='http://www.site.net/ee/adminlogin.php', catid='', threadid='', areaname='adminlogin.php', nopermission = 0 WHERE ip='67.87.179.34';
trued wrote: Unknown column 'validated' in 'where clause'
First, are you sure 'authcode' actually contains a 0 for unvalidated members and a 1 for validated members? A name like 'authcode' doesn't imply such content. If it doesn't, you shouldn't integrate that field.
I got this after removing that line in the script and choosing the script for integration:
Load time so far: 0.22 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Load time so far: 0.24 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 51 for Resource id #37
Load time so far: 0.24 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #39
Load time so far: 0.25 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #40
Load time so far: 0.26 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.26 seconds. Performing query: SELECT member_id,group_id,weblog_id,tmpl_group_id,upload_id,username,screen_name,password,unique_id,authcode,email,url,location,occupation,interests,bday_d,bday_m,bday_y,aol_im,yahoo_im,msn_im,icq,bio,ip_address,join_date,last_visit,total_entries,total_comments,last_entry_date,last_comment_date,last_email_date,in_authorlist,accept_admin_email,accept_user_email,notify_by_default,language,timezone,daylight_savings,localization_is_site_default,time_format,theme,tracker,template_size,notepad,notepad_size,quick_links,pmember_id,links,comments,ip,totalhits,totalhitsin,template,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,validated FROM exp_members WHERE member_id=1 AND validated=1 ;
Load time so far: 0.27 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 0 for Resource id #50
Load time so far: 0.27 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, exp_members WRITE;
Load time so far: 0.27 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #51
Load time so far: 0.28 seconds. Performing query: UNLOCK TABLES;
Warning: Cannot modify header information - headers already sent by (output started at /home/me/public_html/ee/classes/database.php:276) in /home/me/public_html/ee/end.php on line 143
and this is what I get when I try to login, under the login form:
16 total queries This page was created in 0.48 seconds Server Status: time since last reboot is 64 days, 6:00, load average: 0.47, 0.42, 0.40 Load time so far: 0.49 seconds. Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1121999149 AND memberid > 0 ;
Number of rows is 0 for Resource id #63
Load time so far: 0.49 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1121999149;
Load time so far: 0.49 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE ip='67.87.179.34' AND memberid=0 ;
Number of rows is 1 for Resource id #64
Load time so far: 0.49 seconds. Performing query: UPDATE wsnlinks_sessions SET time='1122000049', location='http://www.site.com/ee/adminlogin.php?', catid='', threadid='', areaname='adminlogin.php?', nopermission = 0 WHERE ip='67.87.179.34';
closing database connection
Itlooks like somewhere the url is wrong for login. since it says adminlogin.php instead of admin/login.php.
What you just posted states that you have no errors. Of course as the manual states you can't login/logout when in debug mode due to output coming before cookie headers.
ok,i turned off the debug by putting it on normal.When I went to login I got :
Fatal error: Call to undefined function: replace() in /home/trued/public_html/ee/end.php on line 136
But when I went to index.php?action=userlogin , i caould not login. SO I registered a new account in wsn. Should I be registering this through the other script or wsn? When I went to the table for members of the other script the username and password are missing.
OK, I know I meesed up by trying to register thru wsn because it should now be thru EE. SO when I tried to register a new account with EE I see that there is a member logged in. Im assuming its the admin but I cannot logout for some reason. Maybe its because I have changed the name to ee's index.php to index1.php, so that the wsn directory can have the use of index.php since I merged the files in ftp.
Maybe I should have them in seperate directories..
Anyway, I was able to login to wsn after adding the username to the members table but it showed as 3 members in wsn when it should be 4.Im assuming this is still the effects of the wsn registration instead of the EE.
I think I will have to do a fresh install 4 both scripts and then try the integration again. then register at EE . I think Im getting closer.
I guess im on the right track somehow.. Thanx to your help! If there is anything else you think I should know , please throw at me, Im open to any heads up.Iwill start the fresh install shortly.
I hope this helps others with their integration issues.
OK, I did the fresh install , applied the integration script , have the two scripts in seperate directories and finally registered a new member thru EE and can login thru EE and WSN with that same member info but the only thing that seems to be a problem now is that when I login to wsn I do not see the myself logged into EE too. DO you have any idea why this could be?
BTW, I really appreciate your help. You have really taken alot of time to help everyone here and you are really great . Thank you!
I am having trouble being seen as logged into both scripts at the same time. I can login to both systems but if I login to one I dont see myself logged into the other , and vise versa. I can tell im not logged into wsn becasue I dont see the edit button next to the user name. I kow this integration was succesful in adding the members table from wsn to EE because I can see the fields of wsn in the EE members table. Sooo.. I also have this weird thing happeneing where I logout out of EE and when I try to login to wsn it says it cannot find the username but then I have the password sent to me and then it works. I dont know what thats about.
Does any of this seem like anything youve encountered before. Please advise.. I know Im close to solving this issue and moving on so I cant quit now. Paul Please.. a miracle would be nice but I would settle for anythng you throw at me. thanx!
By the way I cannot login to admin on wsn, even though its the same username and pass as EE.
trued wrote: ok,i turned off the debug by putting it on normal.When I went to login I got :
Fatal error: Call to undefined function: replace() in /home/trued/public_html/ee/end.php on line 136
That doesn't appear related to integration. It means you've somehow killed $template in that spot, overriding it with some other value 'template' being submitted maybe.
I cannot logout for some reason
You set your cookie data incorrectly in one of the programs. Probably you integrated cookies but didn't set in EE to make EE's cookies available where you've installed WSN.
when I login to wsn I do not see the myself logged into EE too. DO you have any idea why this could be?
Like above but you don't have WSN's cookie domain/path set properly either.
Comments on integration script generator
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
I was extremely excited when I read that the integration script generator was added to this latest release.I have it up and running but when I submit the generator fields it takes me to a login screen . I login and try the integration script drop down to select the script I just generated but I dont see any that would be to the one I created. I dont see any members from the other script in the wsn memberlist. SO I know its not integrated yet.
Am I missing a step to this generation? SHould the integration folder have write permissions?
If you have the answer please let me know. This is what I have been waiting for!! thanks.
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
ok, I tried the integration generator again and this time I changed my integrtion directory to have write permissions first and that worked so that I could choose the correct file from the integration drop down. But now I cannot login and I get this message:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/me/public_html/ee/classes/database.php on line 94
I am going to set the integration off in phpmyadmin but I would like to know how I can make this work. how can I fix the error?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It's useless to post a mysql error without the debug info. You haven't posted your integration file either.
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
debug error:
This was below the login form:
integration script:
thanx for the help
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Unknown column 'validated' in 'where clause'
First, are you sure 'authcode' actually contains a 0 for unvalidated members and a 1 for validated members? A name like 'authcode' doesn't imply such content. If it doesn't, you shouldn't integrate that field.
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
ok, so should I just remove that one from the script and thats it?
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
I got this after removing that line in the script and choosing the script for integration:
and this is what I get when I try to login, under the login form:
Itlooks like somewhere the url is wrong for login.
since it says adminlogin.php instead of admin/login.php.
DO I need to change this somehow, if so where?
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
i just looked at the files, it should just be adminlogin.php.. so thats not a problem. I wonder about the error then
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
What you just posted states that you have no errors. Of course as the manual states you can't login/logout when in debug mode due to output coming before cookie headers.
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
ok,i turned off the debug by putting it on normal.When I went to login I got :
But when I went to index.php?action=userlogin , i caould not login. SO I registered a new account in wsn. Should I be registering this through the other script or wsn? When I went to the table for members of the other script the username and password are missing.
Should I still be getting the error above?
I will try registering thru the other script now.
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
OK, I know I meesed up by trying to register thru wsn because it should now be thru EE. SO when I tried to register a new account with EE I see that there is a member logged in. Im assuming its the admin but I cannot logout for some reason. Maybe its because I have changed the name to ee's index.php to index1.php, so that the wsn directory can have the use of index.php since I merged the files in ftp.
Maybe I should have them in seperate directories..
Anyway, I was able to login to wsn after adding the username to the members table but it showed as 3 members in wsn when it should be 4.Im assuming this is still the effects of the wsn registration instead of the EE.
I think I will have to do a fresh install 4 both scripts and then try the integration again. then register at EE . I think Im getting closer.
I guess im on the right track somehow.. Thanx to your help! If there is anything else you think I should know , please throw at me, Im open to any heads up.Iwill start the fresh install shortly.
I hope this helps others with their integration issues.
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
OK, I did the fresh install , applied the integration script , have the two scripts in seperate directories and finally registered a new member thru EE and can login thru EE and WSN with that same member info but the only thing that seems to be a problem now is that when I login to wsn I do not see the myself logged into EE too. DO you have any idea why this could be?
BTW, I really appreciate your help. You have really taken alot of time to help everyone here and you are really great . Thank you!
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
I am having trouble being seen as logged into both scripts at the same time. I can login to both systems but if I login to one I dont see myself logged into the other , and vise versa. I can tell im not logged into wsn becasue I dont see the edit button next to the user name. I kow this integration was succesful in adding the members table from wsn to EE because I can see the fields of wsn in the EE members table. Sooo.. I also have this weird thing happeneing where I logout out of EE and when I try to login to wsn it says it cannot find the username but then I have the password sent to me and then it works. I dont know what thats about.
Does any of this seem like anything youve encountered before. Please advise.. I know Im close to solving this issue and moving on so I cant quit now. Paul Please.. a miracle would be nice but I would settle for anythng you throw at me. thanx!
By the way I cannot login to admin on wsn, even though its the same username and pass as EE.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
ok,i turned off the debug by putting it on normal.When I went to login I got :
That doesn't appear related to integration. It means you've somehow killed $template in that spot, overriding it with some other value 'template' being submitted maybe.
I cannot logout for some reason
You set your cookie data incorrectly in one of the programs. Probably you integrated cookies but didn't set in EE to make EE's cookies available where you've installed WSN.
when I login to wsn I do not see the myself logged into EE too. DO you have any idea why this could be?
Like above but you don't have WSN's cookie domain/path set properly either.
Experienced
Usergroup: Customer
Joined: Oct 10, 2003
Total Topics: 19
Total Comments: 69
Ok, if I understand you correctly I have to make sure the cookie settings are coorect in both scripts.
Would setting the cookie domain be enough for both , or will a path be necessary too.
I have the 2 directories like so:
EE is here: public_html/site/ee/
WSN here: public_html/site/ee/wsn
--
also would Login cookie names: store user id in - wsnuser and password in- wsnpass. have anything to do with it?