how do I use this?

Post by **Oliver Georgi** » Mon 10. Nov 2003, 15:16

Try to create a new admin account in the phpwcms database directy.

INSERT INTO YOUR_PHPWCMS_DB_PREFIXphpwcms_user (usr_login, usr_pass, usr_email, usr_admin, usr_aktiv, usr_name ) VALUES ('admin', PASSWORD('admin'), 'myemail@mydomain.com', 1, 1, 'phpwcms webmaster');

Replace YOUR_PHPWCMS_DB_PREFIX with your db_prepend+_ if you have one - or have a look how this db is named in mysql.

This query will create a user with l/p admin/admin.

Oliver

moe · Post by **moe** » Mon 10. Nov 2003, 15:59

that query gives me an sql error.

this is how my sql phpwcms user table looks like:

Code: Select all

CREATE TABLE phpwcms_user (
  usr_id int(11) NOT NULL auto_increment,
  usr_login varchar(30) NOT NULL default '',
  usr_pass varchar(50) NOT NULL default '',
  usr_email varchar(150) NOT NULL default '',
  usr_tstamp timestamp(14) NOT NULL,
  usr_rechte tinyint(4) NOT NULL default '0',
  usr_admin tinyint(1) NOT NULL default '0',
  usr_avatar varchar(50) NOT NULL default '',
  usr_aktiv int(1) NOT NULL default '0',
  usr_name varchar(100) NOT NULL default '',
  usr_var_structure blob NOT NULL,
  usr_var_publicfile blob NOT NULL,
  usr_var_privatefile blob NOT NULL,
  usr_lang varchar(50) NOT NULL default '',
  PRIMARY KEY  (usr_id)
) TYPE=MyISAM;

#
# Daten für Tabelle `phpwcms_user`
#

INSERT INTO phpwcms_user (usr_id, usr_login, usr_pass, usr_email, usr_tstamp, usr_rechte, usr_admin, usr_avatar, usr_aktiv, usr_name, usr_var_structure, usr_var_publicfile, usr_var_privatefile, usr_lang) VALUES (1, 'webmaster', '43e9a4ab75570f5b', '', 20031109221509, 0, 1, '', 1, 'phpwcms webmaster', '', '', '', '');

Post by **Oliver Georgi** » Mon 10. Nov 2003, 16:01

Then it should be like this:

Code: Select all

INSERT INTO phpwcms_user (usr_login, usr_pass, usr_email, usr_admin, usr_aktiv, usr_name ) VALUES ('admin', PASSWORD('admin'), 'myemail@mydomain.com', 1, 1, 'phpwcms webmaster');

Oliver

moe · Post by **moe** » Mon 10. Nov 2003, 16:34

user:admin / pass: admin , nor user:webmaster / pass: admin lets me login

says error during login. sql entries are ok so it must be a script problem.

btw. sessiondata files are created

Repute · Post by **Repute** » Mon 10. Nov 2003, 16:42

After the login i'am also getting the The page cannot be found error.
I have averything check end done whats discused in this topic and nothing helped also the new admin query...

The script runs on a redhat 9 server running om lampp, imagemagick and ghostscript are installed en my php,mysql versions are the latest.
Tested on IE6 and mozilla (on radhat)...

I love your script but it has to work first i guess

I hope you can manage it out!

Thnx,

Repute

Post by **Oliver Georgi** » Mon 10. Nov 2003, 16:48

Can you send me a login to your FTP account and link to the page?

Oliver

Repute · Post by **Repute** » Mon 10. Nov 2003, 17:05

Ok here you go:

ftp ip:

i mail this to you ok

Login admin:

http://repute.dnsalias.com/repute/login.php

admin
admin

Thnx for your help!!!

Post by **Oliver Georgi** » Mon 10. Nov 2003, 17:28

please change as here - I have no write access:

Code: Select all

// site values
$phpwcms["site"]              = "http://repute.dnsalias.com/";
$phpwcms["admin_email"]       = "webmaster@repute.nl";

// this here prepares also the site value
$phpwcms["root"]         		= "repute";

Oliver

Repute · Post by **Repute** » Mon 10. Nov 2003, 17:41

OOOOOOOPS

Thnx for your help in realtime!

PS the chat and message system gives errors like this:

Parse error: parse error in /opt/lampp/htdocs/repute/include/inc_lib/autolink.inc.php on line 79

Fatal error: Call to undefined function: auto_link() in /opt/lampp/htdocs/repute/include/inc_tmpl/message.center.tmpl.php on line 133

Also when i update my personal info i get this above the header in the admin data updates perfectly so i gues this is an litle error:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /opt/lampp/htdocs/repute/include/inc_lib/profile.update.inc.php on line 46

Whats could that be?

Post by **Oliver Georgi** » Mon 10. Nov 2003, 19:17

Shit - I have updated that function - I will post the old one

Oliver

Post by **Oliver Georgi** » Mon 10. Nov 2003, 19:57

Patch released

Repute · Post by **Repute** » Mon 10. Nov 2003, 20:23

Great everything works still some small bugs...

When updating your profile i get the following message in the upperscreen

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /opt/lampp/htdocs/repute/include/inc_lib/profile.update.inc.php on line 46

http://repute.dnsalias.com

instead of

http://repute.dnsalias.com/repute/phpwc ... o=messages

For the rest I didnt see bugs

Great work!!!

Post by **Oliver Georgi** » Mon 10. Nov 2003, 20:43

Ah yeah there is a mistake - I will correct this - here is the workaround for:

Code: Select all

if($result = mysql_query($sql)) {
	$detail_updated = "Profile data successfully updated.";
	mysql_free_result($result);

corrected:

Code: Select all

if(mysql_query($sql)) {
	$detail_updated = "Profile data successfully updated.";
	// mysql_free_result($result);

Oliver

dfault · Post by **dfault** » Wed 12. Nov 2003, 02:32

Just whanted to let you know that your session fix woked for me! now I can login and make magic!

how do I use this?

Having the same problem...

Great here you go!

Thnx!!!!

Great everything works still some small bugs...