a) I'm trying to understand the database types, could you please confirm me if I'm correct: the default database type would always be mysqli and only if mysqli is not available the isntalled type would be mysqld.
b) Just after setting integration I see the following error, please advice me on how to solve it: (the base table is : wsnlinks4120links, the integrated table is: wsnlinks4120empresas)
Query 2: SELECT `name`,`value` FROM wsnlinks4120empresas_switches WHERE id>0
Number of rows is 92
Load time so far: 0.2 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks4120empresas_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 26
Query 4: SHOW COLUMNS FROM wsnlinks4120empresas_members
Getting field list for table wsnlinks4120empresas_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader
Load time so far: 0.23 seconds.
Load time so far: 0.24 seconds.
Query 5: SELECT `content` FROM wsnlinks_settings WHERE name='dirurl'
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\pruebas\wsnlinks4_1_20_empresas\databases\mysqli.php on line 23
SQL error while fetching row:Table 'test.wsnlinks_settings' doesn't exist
a) Yes except there's no 'mysqld', the alternative is 'mysql'.
b) Integrating links tables, not members? Anyhow it says wsnlinks_settings doesn't exist. Are you trying to integrate settings too, or did you change the tables prefix somehow?
b) I'm integrating member tables of the two installs. One install is links and other install is empresas. I'm not trying to integrate settings table.
I have not modified table prefixes after installation. Table prefixes are: for links installation: wsnlinks4120links_members, wsnlinks4120links_settings, etc. for empresas installation: wsnlinks4120empresas_members, wsnlinks4120empresas_settings, etc.
At the intergation directory of empresas installation , wsnlinks.php has: $memberstable = 'wsnlinks4120links_members';
Comments on database type / integration difficulties
Forum Regular
Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 172
Total Comments: 462
a) I'm trying to understand the database types, could you please confirm me if I'm correct:
the default database type would always be mysqli and only if mysqli is not available the isntalled type would be mysqld.
b) Just after setting integration I see the following error, please advice me on how to solve it:
(the base table is : wsnlinks4120links, the integrated table is: wsnlinks4120empresas)
Query 2: SELECT `name`,`value` FROM wsnlinks4120empresas_switches WHERE id>0
Number of rows is 92
Load time so far: 0.2 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks4120empresas_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 26
Query 4: SHOW COLUMNS FROM wsnlinks4120empresas_members
Getting field list for table wsnlinks4120empresas_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader
Load time so far: 0.23 seconds.
Load time so far: 0.24 seconds.
Query 5: SELECT `content` FROM wsnlinks_settings WHERE name='dirurl'
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\pruebas\wsnlinks4_1_20_empresas\databases\mysqli.php on line 23
SQL error while fetching row:Table 'test.wsnlinks_settings' doesn't exist
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
a) Yes except there's no 'mysqld', the alternative is 'mysql'.
b) Integrating links tables, not members?
Forum Regular
Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 172
Total Comments: 462
b)
I'm integrating member tables of the two installs.
One install is links and other install is empresas. I'm not trying to integrate settings table.
I have not modified table prefixes after installation. Table prefixes are:
for links installation: wsnlinks4120links_members, wsnlinks4120links_settings, etc.
for empresas installation: wsnlinks4120empresas_members, wsnlinks4120empresas_settings, etc.
At the intergation directory of empresas installation ,
wsnlinks.php has: $memberstable = 'wsnlinks4120links_members';
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Just made two installs and integrated them, no problem.
In your integration file, do you have ? wsnlinks_ needs to become your table prefix there. That should only affect the registration page if wrong though.
Forum Regular
Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 172
Total Comments: 462
Thanks Paul this was the difficulty, you can mention it at the manual.
Now I will check and report on the integration count of links as I'm having some difficulties on this .