Support Forums - All Posts - XOOPS Web Application System

11

I need help in converting xoops tables

2005/11/22 2:56
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Hello,

Here's how i end up with thi sproblem. I have ver 2.0.7 and i did an increment update until i got to ver 2.2.3.

i enocuntered a problem with 2.2.3 regarding email activation and opted for downgrade to 2.0.13. well i was able to downgrade but somethings are not the way they used to be.

I back up my SQL tables from 2.2.3 before i downgrade. now i want to restore my xoops_users data to my my current versio which is 2.0.13. There I got error because the fields are not the same anymore.

Here is the table structure for 2.0.13
CREATE TABLE xoops_users (
uid mediumint(8) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
uname varchar(25) NOT NULL default '',
email varchar(60) NOT NULL default '',
url varchar(100) NOT NULL default '',
user_avatar varchar(30) NOT NULL default 'blank.gif',
user_regdate int(10) unsigned NOT NULL default '0',
user_icq varchar(15) NOT NULL default '',
user_from varchar(100) NOT NULL default '',
user_sig tinytext NOT NULL,
user_viewemail tinyint(1) unsigned NOT NULL default '0',
actkey varchar(8) NOT NULL default '',
user_aim varchar(18) NOT NULL default '',
user_yim varchar(25) NOT NULL default '',
user_msnm varchar(100) NOT NULL default '',
pass varchar(32) NOT NULL default '',
posts mediumint(8) unsigned NOT NULL default '0',
attachsig tinyint(1) unsigned NOT NULL default '0',
rank smallint(5) unsigned NOT NULL default '0',
level tinyint(3) unsigned NOT NULL default '1',
theme varchar(100) NOT NULL default '',
timezone_offset float(3,1) NOT NULL default '0.0',
last_login int(10) unsigned NOT NULL default '0',
umode varchar(10) NOT NULL default '',
uorder tinyint(1) unsigned NOT NULL default '0',
notify_method tinyint(1) NOT NULL default '1',
notify_mode tinyint(1) NOT NULL default '0',
user_occ varchar(100) NOT NULL default '',
bio tinytext NOT NULL,
user_intrest varchar(150) NOT NULL default '',
user_mailok tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (uid),
KEY uname (uname),
KEY email (email),
KEY uiduname (uid,uname),
KEY unamepass (uname,pass)
) TYPE=MyISAM;

and here is the structure that i have in my backup

CREATE TABLE xoops_users (
uid mediumint(8) unsigned NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
uname varchar(55) NOT NULL default '',
loginname varchar(25) NOT NULL default '',
email varchar(60) NOT NULL default '',
user_avatar varchar(30) NOT NULL default 'blank.gif',
pass varchar(32) NOT NULL default '',
rank smallint(5) unsigned NOT NULL default '0',
level tinyint(3) NOT NULL default '0',
PRIMARY KEY (uid),
KEY uname (uname),
KEY email (email),
KEY uiduname (uid,uname),
KEY unamepass (uname,pass)
) TYPE=MyISAM;

Can anyone please help me! Thanks in advance

12

Re: Why can't new registration unable to receive activation key

2005/11/18 14:44
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Quote:

Bananadude wrote:
not with me, the only module that I've translated that is shipped with 2.2.x is PM

But as you see in this Topic it was server-related.

[edit]: Now the mailfunction works again it was server-related, suddenly a bunch of mails popped up in my inbox
Ask your server-admin jakeabiva, maybe you don't have permission to the sendmail binary, yet.

I will follow your advise first Bananadude, I will ask my server hosting.

I used pure english by the way...

Thanks

13

Why can't new registration unable to receive activation key

2005/11/16 9:19
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Hello,

I've been searching the forum for help but found none.

Using ver 2.2.3 upgraded incrementally from 2.0.7 .....

News users registration by activation works fine before but when I upgraded to 2.2.3, its not working anymore.

I tried changing mail setup phpmail() & sendmail(), nothing wokrs. Activation key still won;t work.

please help

14

Re: Activation Link fix test

2005/11/16 8:06
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Hi,

Are you ver 2.2.3? Because I did not find this code on my common.php. I'm using 2.2.3

Quote:

Mithrandir wrote:
First job for the beta testing team, until we get the infrastructure finalised:

Could you try replacing
if (!strpos(XOOPS_URL, "http")) { //Relative URL used, calculate absolute URL $protocol = strtolower(substr($_SERVER['SERVER_PROTOCOL'], 0, strpos($_SERVER['SERVER_PROTOCOL'], "/", 0))); define("XOOPS_ABS_URL", $protocol."://".$_SERVER['HTTP_HOST'].XOOPS_URL); } else { define("XOOPS_ABS_URL", XOOPS_URL); }

with
if (strpos(XOOPS_URL, "http") === 0) { define("XOOPS_ABS_URL", XOOPS_URL); } else { //Relative URL used, calculate absolute URL $protocol = strtolower(substr($_SERVER['SERVER_PROTOCOL'], 0, strpos($_SERVER['SERVER_PROTOCOL'], "/", 0))); define("XOOPS_ABS_URL", $protocol."://".$_SERVER['HTTP_HOST'].XOOPS_URL); }

in include/common.php (around lines 119-126)

Then see if it fixes the activation link as well as other links in emails.

Thanks

15

Re: How do I activate registration via webmasters?

2005/11/16 7:21
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Thanks Lance for the help

Quote:

Lance_ wrote:
Go to Modules ---> Extended Profiles

From there Search or List to get your user. Click Add.

Change to Active.

16

How do I activate registration via webmasters?

2005/11/14 4:49
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

I accidentally set the new registration to activation by webmasters.

But I can't find a way to activate it. I tried FIND USERS and found an inactive users but when I select it, a new page came out saying users not found.

Please help, I'm using versions 2.2.3

Thanks!

17

Re: News 1.42 how to creating links that target top page

2005/11/11 8:41
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Here is the download links to News 1.42


http://dev.xoops.org/modules/xfmod/project/showfiles.php?group_id=1008&release_id=683&dl=1905

by the way here is the code that should have display in my post


http://ivcfphil.org/modules/news/article.php?storyid=7

I want this link to open up in top page

18

News 1.42 how to creating links that target top page

2005/11/11 7:11
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Hello everyone,

Using news 1.42, and created links using the button. Here is my samplle link.

Part 3

This code always open in new window in my browser. I would like to open it in the same window like in normal target=_top code.

Thanks!!!

19

Help in updating XOOPS

2005/11/3 15:18
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Need help from you guys:

i have 2.0.13.1 somthing on my server, downloaded update for 2.2.3 copy all files to XOOPS directory then opened htttp://mysite.com/install/; and heres what i got. I know I did something wrong, please tell me what?
PHP 4 , MySQL 4

Warning: main(./passwd.php): failed to open stream: No such file or directory in /home/webtek/public_html/install/index.php on line 30

Warning: main(): Failed opening './passwd.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/webtek/public_html/install/index.php on line 30

Notice: Use of undefined constant INSTALL_USER - assumed 'INSTALL_USER' in /home/webtek/public_html/install/index.php on line 31

Warning: Cannot modify header information - headers already sent by (output started at /home/webtek/public_html/install/index.php:30) in /home/webtek/public_html/install/index.php on line 33

Warning: Cannot modify header information - headers already sent by (output started at /home/webtek/public_html/install/index.php:30) in /home/webtek/public_html/install/index.php on line 34
You can not access this XOOPS installer.

20

Another Install Problem

2005/10/12 3:30
jakeabiva
Just popping in
Posts: 20
Since: 2005/6/25

Hi,

I searched for a topic regarding my install problem, but found none so I will post it here.

My server setup: Apache 2.0.54 win 32, MySQL 5.0.4, PHP 4.4.0,

I'm installing in my PC using windows XP Pro edittion:

Here is my first error message right after I press the next button on the install wizard:

Notice: Only variables should be assigned by reference in D:\htdocs\install\class\textsanitizer.php on line 86

Notice: Only variables should be assigned by reference in D:\htdocs\install\class\textsanitizer.php on line 86

Notice: Only variables should be assigned by reference in D:\htdocs\install\class\textsanitizer.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at D:\htdocs\install\class\textsanitizer.php:86) in D:\htdocs\install\index.php on line 99

Pressing the Next Button show this message:

Notice: Only variables should be assigned by reference in D:\htdocs\install\class\textsanitizer.php on line 86

Notice: Only variables should be assigned by reference in D:\htdocs\install\class\textsanitizer.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at D:\htdocs\install\class\textsanitizer.php:86) in D:\htdocs\install\index.php on line 99

and so forth, everytime I hit next new message pops out and on the part where XOOPS will create database,

Could not connect to the database server

please help thanks

Jake

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

I need help in converting xoops tables

Re: Why can't new registration unable to receive activation key

Why can't new registration unable to receive activation key

Re: Activation Link fix test

Re: How do I activate registration via webmasters?

How do I activate registration via webmasters?

Re: News 1.42 how to creating links that target top page

News 1.42 how to creating links that target top page

Help in updating XOOPS

Another Install Problem

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}