|
|
| Author |
Message |
bossman
Staff Sergeant
Joined: 26 Nov 2003
Posts: 50
|
 Posted: Wed Nov 26, 2003 8:52 am Post subject: I can't make my Admin acount work |
|
 |
|
i did the test.php that you talked about in your other post's chris
and every thing looks fine now i go to log in to my site
and make supper user i get to make it but when i get the admin login it takes me back to the make supper use page
can you help
this is what it says:
| Code: |
There are no Administrators Accounts yet, proceeed to create the Super User
|
i try and make one but not working! |
|
| Back to top |
|
 |
chris
Dark Lord of the Sith
Joined: 10 May 2003
Posts: 6262
Location: Outer Space
|
| Posted: Wed Nov 26, 2003 12:18 pm Post subject: |
|
|
|
This is the _NOADMINYET message whose translation you can find in the various language files in the language folder. It occurs in admin.php:
| Code: |
$the_first = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_authors"));
if ($the_first == 0) {
if (!$name) {
include("header.php");
title("$sitename: "._ADMINISTRATION."");
OpenTable();
echo "<center><b>"._NOADMINYET."</b></center><br><br>"
|
From the code we see that it is echoed only if $the_first is 0, meaning no entries in the $prefix_authors table.
Thus, for some reason, the nuke_authors table (assuming your $prefix is "nuke" in config.php), is not filled. Could you check the entries in nuke_authors? You can do this either from the MySQL prompt with
| Code: |
select aid, name, email, pwd from nuke_authors;
|
or with the "browse" function of phpMyAdmin.
If your Super Admin is there, then it is weird...
If the Super Admin is not there, then you can't write to the database. To check this possibility, find the function create_first() in admin.php. There, you will see two lines with a call to sql_query. They are both identical:
| Code: |
$db->sql_query($sql);
|
Insert the line:
| Code: |
echo mysql_error();
|
after each one. This will echo a more descriptive error message and may lead you to the solution.
_________________
Regards
Chris Karakas
www.karakas-online.de |
|
| Back to top |
|
|
bossman
Staff Sergeant
Joined: 26 Nov 2003
Posts: 50
|
| Posted: Wed Nov 26, 2003 2:44 pm Post subject: i cant make my Admin acount work |
|
|
|
NO there is no supper amdin on nuke_authors
the only thing i seen was
| Code: |
aid varchar(25) No Change Drop Primary Index Unique Fulltext
name varchar(50) Yes NULL Change Drop Primary Index Unique Fulltext
url varchar(255) No Change Drop Primary Index Unique Fulltext
email varchar(255) No Change Drop Primary Index Unique Fulltext
pwd varchar(40) Yes NULL Change Drop Primary Index Unique Fulltext
|
? im close just dont know how close .. i hope
[edit] Included code in code tags. Chris [/edit] |
|
| Back to top |
|
|
bossman
Staff Sergeant
Joined: 26 Nov 2003
Posts: 50
|
| Posted: Wed Nov 26, 2003 2:53 pm Post subject: i cant make my Admin acount work |
|
|
|
Aslo wanted to add that i used the analyze.php
and i got back this
| Code: |
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\FoxServ\www\analyze.php on line 738
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\FoxServ\www\analyze.php on line 756
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\FoxServ\www\analyze.php on line 761
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\FoxServ\www\analyze.php on line 764
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\FoxServ\www\analyze.php on line 769
|
Dont know if its of any help to you in finding whats going on here..
[edit] Included code in code tags. Chris [/edit] |
|
| Back to top |
|
|
chris
Dark Lord of the Sith
Joined: 10 May 2003
Posts: 6262
Location: Outer Space
|
| Posted: Wed Nov 26, 2003 6:08 pm Post subject: Re: i cant make my Admin acount work |
|
|
|
| bossman wrote: |  Aslo wanted to add that i used the analyze.php
and i got back this
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\FoxServ\www\analyze.php on line 738
 |
You can't connect to the database. Check your config.php again.
A frequent error is that people write "mysql" instead of "MySQL" for the dbtype. Check this and all the other values in config.php again.
_________________
Regards
Chris Karakas
www.karakas-online.de |
|
| Back to top |
|
|
bossman
Staff Sergeant
Joined: 26 Nov 2003
Posts: 50
|
| Posted: Wed Nov 26, 2003 7:23 pm Post subject: i cant make my Admin acount work |
|
|
|
this is my config.php Every thing looks Ok i think
| Code: |
$dbhost = "localhost";
$dbuname = "timmy";
$dbpass = "stoper";
$dbname = "MySQL";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SdFk*fa28367-dm56w69.3a2fDS+me";
$gfx_chk = 0;
|
[edit] Included code in code tags. Chris [/edit] |
|
| Back to top |
|
|
chris
Dark Lord of the Sith
Joined: 10 May 2003
Posts: 6262
Location: Outer Space
|
| Posted: Wed Nov 26, 2003 7:38 pm Post subject: |
|
|
|
dbname is wrong. Unless you named your database "MySQL"... 
The user timmy must have all privileges for the database.
_________________
Regards
Chris Karakas
www.karakas-online.de |
|
| Back to top |
|
|
bossman
Staff Sergeant
Joined: 26 Nov 2003
Posts: 50
|
| Posted: Wed Nov 26, 2003 8:14 pm Post subject: i cant make my Admin acount work |
|
|
|
| the db name ? what do i put ? |
|
| Back to top |
|
|
bossman
Staff Sergeant
Joined: 26 Nov 2003
Posts: 50
|
| Posted: Wed Nov 26, 2003 9:08 pm Post subject: i cant make my Admin acount work |
|
|
|
i got it wow thanks you Rock .......
 But now ppl paged me back about site.
To me it looks fine but on there side they see Boxs and sysbols what can this Be...
Take a look www.webbroz.co.nr |
|
| Back to top |
|
|
chris
Dark Lord of the Sith
Joined: 10 May 2003
Posts: 6262
Location: Outer Space
|
| Posted: Thu Nov 27, 2003 12:51 am Post subject: Re: i cant make my Admin acount work |
|
|
|
I started writing this, but was interrupted, then I saw that you fixed your problem with the database. I am posting it anyway:
| bossman wrote: | | the db name ? what do i put ?
|
You created a database before you installed PHP-Nuke, didn't you?
See How to install PHP-Nuke manually.
_________________
Regards
Chris Karakas
www.karakas-online.de |
|
| Back to top |
|
|
|
|
|
|
|
FAQ
Forum Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
