wont save pm settings: PHPFusion 6 Support

Home
Search

Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

Hi

about my privat massages problem, i have now found out of that, when i go to the admin page and to private messages, and enter like the pictures i have add to the thread.

when i press save, nothing happens the save dosent "save" :(

0 replies

Try to preview this code in a custom page:

Code Download source

<?php
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}messages_options");
if (mysql_num_rows($result) > 0) {
echo "<table class='tbl-border'>\n<td colspan='2'><b>messages_options Table Scheme</b></td>\n";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class='tbl1'>".$row[0]."</td><td class='tbl2'>".$row[1]."</td></tr>\n";
}
echo "</table>\n";
}
?>

You should get a table structure like this if your table is ok:

user_id smallint(5) unsigned
pm_email_notify tinyint(1) unsigned
pm_save_sent tinyint(1) unsigned
pm_inbox smallint(5) unsigned
pm_savebox smallint(5) unsigned
pm_sentbox smallint(5) unsigned

If you don't get a structure like this then please post your result here.

Which version are you running?

0 replies

this i what i get

Code Download source

messages_options Table Scheme 
user_id smallint(5) unsigned 
pm_email_notify tinyint(1) unsigned 
pm_save_sent tinyint(1) unsigned 
pm_inbox smallint(5) unsigned 
pm_savebox smallint(5) unsigned 
pm_sentbox smallint(5) unsigned

using the newest version it works fine, until i shift server to servage had b-one.net before

0 replies

Seems like your database table should be ok.

What happens when you hit save settings? Are you redirected to index page or is just nothing happening?

Does your browser show the ending of the url like this?:

administration/settings_messages.php?aid=bdec48d96292ae78

If you have an outdated settings_messages.php it may display the page ok, but you will be redirected to the index page.

Are other settings in the admin panel not saved either or is it only in the PM settings page?

You could try to upload a fresh copy of settings_messages.php and see if it changes anything.

0 replies

Quote

WEC_Admin wrote:
Seems like your database table should be ok.

What happens when you hit save settings? Are you redirected to index page or is just nothing happening?

wen i press save, the page update and i stand on the same page. butt the "data" i press in "20" is gone

Quote

Does your browser show the ending of the url like this?:

administration/settings_messages.php?aid=bdec48d96292ae78

Yes.

If you have an outdated settings_messages.php it may display the page ok, but you will be redirected to the index page.

Quote

Are other settings in the admin panel not saved either or is it only in the PM settings page?

all others are save ok.

Quote

You could try to upload a fresh copy of settings_messages.php and see if it changes anything.

done with no luck.

Edited by hamsterx2 on 11-08-2006 11:52, 18 y

0 replies

Try to preview this in a custom page and then check if the PM settings are updated in your settings_messages.php:

Code Download source

<?php
$data = dbquery("UPDATE ".$db_prefix."messages_options SET 
      pm_email_notify = '1',
      pm_save_sent = '0',
      pm_inbox = '20',
      pm_sentbox = '20',
      pm_savebox = '20'
      WHERE user_id='0'"
   );
echo "PM settings updated";
?>

0 replies

Quote

WEC_Admin wrote:
Try to preview this in a custom page and then check if the PM settings are updated in your settings_messages.php:

Code Download source

<?php
$data = dbquery("UPDATE ".$db_prefix."messages_options SET 
      pm_email_notify = '1',
      pm_save_sent = '0',
      pm_inbox = '20',
      pm_sentbox = '20',
      pm_savebox = '20'
      WHERE user_id='0'"
   );
echo "PM settings updated";
?>

done it says pm setting update, butt i still cant send pmm.

0 replies

That's a new problem you introduce. Let's try to fix the original one first.

When you go to administration/settings_messages.php do you now see figures 20, 20, 20 in inbox, outbox and archive limit?

0 replies

Quote

WEC_Admin wrote:
That's a new problem you introduce. Let's try to fix the original one first.

When you go to administration/settings_messages.php do you now see figures 20, 20, 20 in inbox, outbox and archive limit?

nope i still look like the pic in my first thread :(

0 replies

Falk

answered 11 Aug 2006 at 03:29 PM

Super Admin

Lets see if the table structure is ok, paste this into custom pages, preview it, tell us what you see

Code Download source

<?php
opentable("Table Structure");
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}messages_options");
if (mysql_num_rows($result) > 0) {
echo "<table cellspacing='1' cellpadding='0' class='tbl-border'>\n<td colspan='2' class='tbl2'><b>messages_options Table Scheme</b></td>\n";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class='tbl1'>".$row[0]."</td><td class='tbl2'>".$row[1]."</td></tr>\n";
}
echo "</table>\n";
}
closetable();
?>

0 replies

Quote

Digitanium wrote:
Lets see if the table structure is ok, paste this into custom pages, preview it, tell us what you see

Code Download source

<?php
opentable("Table Structure");
$result = mysql_query("SHOW COLUMNS FROM {$db_prefix}messages_options");
if (mysql_num_rows($result) > 0) {
echo "<table cellspacing='1' cellpadding='0' class='tbl-border'>\n<td colspan='2' class='tbl2'><b>messages_options Table Scheme</b></td>\n";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class='tbl1'>".$row[0]."</td><td class='tbl2'>".$row[1]."</td></tr>\n";
}
echo "</table>\n";
}
closetable();
?>

this is what i get

Code Download source

messages_options Table Scheme 
user_id smallint(5) unsigned 
pm_email_notify tinyint(1) unsigned 
pm_save_sent tinyint(1) unsigned 
pm_inbox smallint(5) unsigned 
pm_savebox smallint(5) unsigned 
pm_sentbox smallint(5) unsigned

0 replies

Try WEC_Admins code again in custom pages but this time with a little addition:

Code Download source

<?php
$data = dbquery("UPDATE ".$db_prefix."messages_options SET 
pm_email_notify = '1',
pm_save_sent = '0',
pm_inbox = '20',
pm_sentbox = '20',
pm_savebox = '20'
WHERE user_id='0'"
) [color=red]or die(mysql_error())[/color];
echo "PM settings updated";
?>

The additional code is in red. This tells the script to halt and throw a mysql error. It apears you have some type of issue with mysql. That's just a guess but worth a shot.

0 replies

Quote

kejonn wrote:
Try WEC_Admins code again in custom pages but this time with a little addition:
Code Download source
<?php
$data = dbquery("UPDATE ".$db_prefix."messages_options SET 
pm_email_notify = '1',
pm_save_sent = '0',
pm_inbox = '20',
pm_sentbox = '20',
pm_savebox = '20'
WHERE user_id='0'"
) [color=red]or die(mysql_error())[/color];
echo "PM settings updated";
?>
The additional code is in red. This tells the script to halt and throw a mysql error. It apears you have some type of issue with mysql. That's just a guess but worth a shot.

its that same., says pm settings save, butt nothing is save :(

0 replies

Falk

answered 11 Aug 2006 at 07:41 PM

Super Admin

Run this and see what you get:

Code Download source

<?php
echo "Rows with user_id 0 = ".dbcount("(*)","messages_options","user_id='0'");
?>

0 replies

Well, then this is rather simple then...you don't have a user_id of 0 in your table! At least that's the logical answer. Preview this code in custom pages:

Code Download source

<?php
$result = dbquery("SELECT * FROM ".$db_prefix."messages_options");
if (dbrows($result) > 0) {
while ($row=dbarray($result)) {
echo "User id: ".$row['user_id']."<br>";
}
}
else echo "message_options is empty";
?>

And for future reference, you don't need to quote our responses back in your response. Just give us your response.

EDIT: Digi beat me to it in a different way...

Edited by kejonn on 11-08-2006 19:45, 18 y

0 replies

Quote

Digitanium wrote:
Run this and see what you get:
Code Download source
<?php
echo "Rows with user_id 0 = ".dbcount("(*)","messages_options","user_id='0'");
?>

it says this

Code Download source

Rows with user_id 0 = 0

and the error is still the same :(

0 replies

Falk

answered 11 Aug 2006 at 08:02 PM

Super Admin

Thats it, theres no default row, fix:

Code Download source

<?php
$result = dbquery("INSERT INTO ".$db_prefix."messages_options (user_id, pm_email_notify, pm_save_sent, pm_inbox, pm_savebox, pm_sentbox) VALUES ('0', '0', '1', '20', '20', '20')");
echo "messages_options defaults restored";
?>

0 replies

Weeeeeeeeeeeee. thanks digi, that fix it ;)

0 replies

Category Forum

Bugs and Errors - 6

Labels

None yet

Statistics

Views 0 views
Posts 17 posts
Votes 0 votes
Topic users 4 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

wont save pm settings

17 posts

PHPFusion

Resources

Community

Development