Webmastersite.net
Register Log In

integration script generator
SO very happy for this but...

Comments on integration script generator

trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
Posted Jul 20, 2005 - 11:08 PM:

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!! smiling face thanks.
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
Posted Jul 20, 2005 - 11:26 PM:

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?
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 21, 2005 - 1:06 PM:

It's useless to post a mysql error without the debug info. You haven't posted your integration file either.
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
Posted Jul 21, 2005 - 3:27 PM:

debug 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';


closing database connection

integration script:

<?php
$memberstable = 'exp_members';

$newusergroup = 'group_id';
$newname = 'username';
$newid = 'member_id';
$newpassword = 'password';
$newemail = 'email';
$newtime = 'join_date';
$newip = 'ipaddress';
$newvalidated = 'authcode';
$newsignature = '';
$newlocation = 'location';
$newbio = 'bio';
$newhomepage = 'url';
$newoccupation = 'occupation';
$newaim = 'aol_im';
$newmsn = 'msn_im';
$newicq = 'icq';
$newyahoo = 'yahoo_im';
$newcustomtitle = '';
$newinterests = 'interests';
$newsalt = '';

$otherencoder = 'no';

$admingroup = '1';
$group4 = '';
$group5 = '';

$idcookiename = '';
$passwordcookiename = '';
$cookietype = '';
$idindex = '';
$passwordindex = '';
$cookieidtype = '';

?>


thanx for the help smiling face
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 21, 2005 - 7:56 PM:

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.
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
Posted Jul 21, 2005 - 9:39 PM:

ok, so should I just remove that one from the script and thats it?
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
Posted Jul 21, 2005 - 9:45 PM:

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.

DO I need to change this somehow, if so where?
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
Posted Jul 21, 2005 - 9:52 PM:

i just looked at the files, it should just be adminlogin.php.. so thats not a problem. I wonder about the error then
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 22, 2005 - 6:07 PM:

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.
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
#10 - Quote - Permalink
Posted Jul 22, 2005 - 9:45 PM:

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.


Should I still be getting the error above?

I will try registering thru the other script now.
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
#11 - Quote - Permalink
Posted Jul 22, 2005 - 10:09 PM:

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.
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
#12 - Quote - Permalink
Posted Jul 23, 2005 - 12:52 AM:

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!

trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
#13 - Quote - Permalink
Posted Jul 23, 2005 - 1:34 PM:

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. smiling face thanx!

By the way I cannot login to admin on wsn, even though its the same username and pass as EE.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#14 - Quote - Permalink
Posted Jul 23, 2005 - 3:42 PM:

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.
trued
Experienced

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 19
Total Comments: 69
trued
#15 - Quote - Permalink
Posted Jul 23, 2005 - 9:01 PM:

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?
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.