I am currently testing amember for use with www.talieoh.com which is run on xoops. Currently i'm using custom php code to interface with xoops and verotel, but it has problems, specialy with updating users. amember is a much better overall solution which i would like to migrate too. I installed the xoops plugin in the amember CP, but when I try to add a subscription to a member I get the following error: PHP: MYSQL ERROR: Table 'demo_xoops.xoops_user_profile' doesn't exist in query: INSERT INTO demo_xoops.xoops_user_profile (profileid, user_regdate, user_viewemail, umode ) VALUES ('2', '1162180977', 1, 'nest' ) looking at the xoops database there is no table named "xoops_user_profile" only thing close is "xoops_users". Is this xoops plugin really out of date or something? this is the sole purpose I wish to use amember, for xoops intigration.
I did this and it connects to my database just fine but I still get this error I may be wrong but I think there was a module before that used that table that is no longer a default install. I am trying to look through my old versions of xoops for it, so far no luck. I believe the combined this table with the users table in the later versions, but dont quote me on this.
there is an error in the plugin. If you are a customer then they will give you the new plugin if your subscription is active. If using the free trail version I do not know how they will handle that. Please contact support.
Alex, Since this post has the XOOPS plugin changed? I have not used my site for some time now. I dont even remember the username and password to get into it LOL. Just wondering if I have to download a new xoops plugin to work with xoops 2.0.16 when I upgrade my site. Thanks Churchill
I just downloaded the plugin today and I'm trying to use it with xoops 2.0.16 and I get the error. Looks like the plug-in is referencing a table that isn't there? MYSQL ERROR: Table 'db_xoop1.xoops_user_profile' doesn't exist in query: INSERT INTO db_xoop1.xoops_user_profile (profileid, user_regdate, user_viewemail, umode ) VALUES ('3', '1184730980', 1, 'nest' ) Cut and Paste of database fields db_xoop1.xoops_tplset OK db_xoop1.xoops_tplsource OK db_xoop1.xoops_users OK db_xoop1.xoops_weblinks_atomfeed OK db_xoop1.xoops_weblinks_broken OK I don't see that I have a xoops_user_profile table.
Hi, You seem to be using the famous NON-Recommended version of xoops, i.e. 2.2.4 or 2.2.5... In this version, there are some bugs. If you de-installed some xoops modules, or payed with some system modules, PM management, etc, then it would HAVE de-installed the profiles table without barking. The best is to install the xoops in anathor database, get the user_profiles structure in the current xoops thereby re-constructing the profiles table data structure. Thereafter you just need to manually add certain profile numbers in that profiles table and everything will work again. Get it?