Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 141
Total Posts: 369
Posted 12/13/07 - 06:33 PM:
#1
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`,`original close`,`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,al lowemail,signature,avatarname,stylesheet,allowuseremail,albu mid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit, timezone,rating,pmfolders,notifyofpms,acceptpms,cookiedurati on,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo ,inactive,timeonline,totalpms,buddies,ignored,isonline,accep tims,adminpermissions,referrer,groupreverttime,grouprevertto ,moderationpm,secondarygroups,linksperpage,commentsperpage,s houts,customtitle,shoutban,topicbans,forumbans,visibility,bi rthdate,lastsession,interests,posteditor,forumaccess,pmpopup ,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag ,orderalbums,lastguestnote,autosubscribe,notifymethod,showav atars,showsigs,warninglevel,topics,posts,chatcolor,traderrat ing,invitessent,validatedemail,calsub,macros,guestnotify,key checktime,notifykeywords,autosubscribepost,blogrss,positivep ct,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\my sqli.php on line 23
SQL error while fetching row:Table 'test.wsnlinks_settings' doesn't exist
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844
Posted 12/14/07 - 11:21 AM:
#2
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?
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 141
Total Posts: 369
Posted 12/14/07 - 07:19 PM:
#3
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';
? wsnlinks_ needs to become your table prefix there. That should only affect the registration page if wrong though.
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Print
database type / integration difficulties
Anyhow it says wsnlinks_settings doesn't exist. Are you trying to integrate settings too, or did you change the tables prefix somehow?