Email me a copy of the backup
2,726 2007-06-21 17:56
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
2,727 2007-06-21 17:50
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
Interesting 
That would be a database backup, that should have what you need to restore.
2,728 2007-06-21 17:39
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
Oh, I don't think that refers to PunBB, I think that refers to your control panel users.
And I don't know if your site backup includes a database backup.
2,729 2007-06-21 16:10
Re: Changeset 969 - topics => first_post_id (14 replies, posted in PunBB 1.2 discussion)
Exactly.
Lots of syndication scripts want to grab the first post of the topic (for posting on the front page, etc) but before, there was no easy/efficent way to do that simply given the topic. Now, since the first post ID is stored on the topics table, you can easily access the first post of the topic (as Bekko demonstrated).
2,730 2007-06-21 13:48
Re: sendmail or smtp host (11 replies, posted in PunBB 1.2 troubleshooting)
Edit register.php/profile.php to remove the option to choose email settings (make the setting that's used for new users 2). Then, set that setting for all existing users.
2,731 2007-06-21 13:30
Re: sendmail or smtp host (11 replies, posted in PunBB 1.2 troubleshooting)
Turn off the features that require email that you have enabled?
2,732 2007-06-21 13:28
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
Well, since only the users table crashed, the posts should still exist in the database. The only thing you need to do is add the users back with the proper IDs.
And the backup I'm referring to is the one you have been referring to (I'm not sure what you mean by backing up the user list though, you backed up the users table?)
2,733 2007-06-21 13:20
Re: sendmail or smtp host (11 replies, posted in PunBB 1.2 troubleshooting)
If your host restricts mail, they probably don't want you using sendmail, since the mail function simply acts as a wrapper.
2,734 2007-06-21 13:15
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
Assuming the backup is of all your PunBB tables, yes, restoring it would restore your forum to the state it was when it was backed up.
However, since only the users table crashed, you should only need to restore two rows. In fact, if you sent me a copy of the backup (smartys@ this site) and told me which usernames to look for, I should be able to give you the two queries to run to add them back.
2,735 2007-06-21 13:09
Re: sendmail or smtp host (11 replies, posted in PunBB 1.2 troubleshooting)
If your host restricts mail, they probably don't want you using sendmail
2,736 2007-06-21 12:58
Re: sendmail or smtp host (11 replies, posted in PunBB 1.2 troubleshooting)
Many SMTP servers work, I've personally never had an issue
And it looks like that's a restriction by your host as well: the permission denied on connect is something you need to ask them about
2,737 2007-06-21 12:46
Re: Add GeSHi in the parser (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Could you paste your copy of parser.php?
2,738 2007-06-21 12:45
Re: sendmail or smtp host (11 replies, posted in PunBB 1.2 troubleshooting)
That error indicates the server isn't responding.
Keep in mind that PunBB doesn't support SMTP servers which require SSL (like Gmail).
And I'd need to see the other errors to figure out anything from them
2,740 2007-06-21 12:19
Re: Add GeSHi in the parser (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Moved to Modifications
2,741 2007-06-21 12:19
Re: Database Crash - Lost users - A few questions (25 replies, posted in PunBB 1.2 troubleshooting)
Assuming the backup is a backup of your database, yes, but you'll need to edit it so that you're only restoring the two users.
2,742 2007-06-21 03:07
Re: Unable to connect to MySQL server (3 replies, posted in PunBB 1.2 troubleshooting)
That error means your username/password combination is invalid. If it worked before, talk to your host.
2,743 2007-06-21 02:30
Re: Unable to connect to MySQL server (3 replies, posted in PunBB 1.2 troubleshooting)
Make sure your MySQL username and password are correct and that your MySQL host is correct
2,744 2007-06-20 23:01
Re: Easy BBCode 1.0.1 (139 replies, posted in PunBB 1.2 modifications, plugins and integrations)
The image type is like a submit button. Instead of making them input tags, simply make them regular image tags
2,745 2007-06-20 22:52
Re: Two problems with forum (16 replies, posted in PunBB 1.2 troubleshooting)
I don't see any issues glaring at me in that file, you could paste the rest of the CSS for that style?
2,746 2007-06-20 13:12
Re: Two problems with forum (16 replies, posted in PunBB 1.2 troubleshooting)
.tcl {TEXT-ALIGN: left; WIDTH: 57%}
.tc2, .tc3, .tcmod {WIDTH: 15%; TEXT-ALIGN: center}
.tcr {WIDTH: 28%; TEXT-ALIGN: left}I wasn't clear before, but it should be
first line width + (2 * second line width) + third line width = 100%
2,747 2007-06-20 12:58
Re: Two problems with forum (16 replies, posted in PunBB 1.2 troubleshooting)
Hmm, could you paste your CSS?
2,748 2007-06-20 12:44
Re: Two problems with forum (16 replies, posted in PunBB 1.2 troubleshooting)
Did this start happening after you made the changes here?
2,749 2007-06-20 11:45
Re: Two problems with forum (16 replies, posted in PunBB 1.2 troubleshooting)
1. In base.css
.tcl {TEXT-ALIGN: left; WIDTH: 50%}
.tc2, .tc3, .tcmod {WIDTH: 9%; TEXT-ALIGN: center}
.tcr {WIDTH: 32%; TEXT-ALIGN: left}Alter the percents so that they still add up to 100 but tc2 and tc3 have more than 9% of the width
2.
DIV.postleft, DIV.postfootleft {
FLOAT:left;
WIDTH: 18em;
OVERFLOW: hidden;
POSITION: relative;
}
DIV.postright, DIV.postfootright {
BORDER-LEFT-WIDTH: 18em;
BORDER-LEFT-STYLE: solid
}Change 18em to something smaller
2,750 2007-06-20 11:40
Re: viewtopic.php mod installing error (11 replies, posted in PunBB 1.2 troubleshooting)
I am being clear.
The code you're looking at looks like this for an unmodded PunBB
$result = $db->query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id LEFT JOIN '.$db->prefix.'online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id='.$id.' ORDER BY p.id LIMIT '.$start_from.','.$pun_user['disp_posts'], true) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());I want you to add g.g_color to the column list there, like this
$result = $db->query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, g.g_color, o.user_id AS is_online FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id LEFT JOIN '.$db->prefix.'online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id='.$id.' ORDER BY p.id LIMIT '.$start_from.','.$pun_user['disp_posts'], true) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());