Re: [Release] Database Management Plugin
ok i've fixed it and mailed the new version to rickard
$index[$kname] = array();
should be
if (!isset($index[$kname]))
$index[$kname] = array();
- Connorhd
- Former PunBB Developer
- Offline
Re: [Release] Database Management Plugin
Verry nice Plugin Connorhd
Working fine for me on free.fr host.
Just a question:
can you added a protected : (Enclose table and field names with backquotes) ?
or is not required ?
Thank again for this good plug.
- Connorhd
- Former PunBB Developer
- Offline
Re: [Release] Database Management Plugin
sorry i don't understand what you mean 
54 2005-04-15 16:27 (edited by klacksa 2005-04-15 16:32)
Re: [Release] Database Management Plugin
Connorhd wrote:
sorry i don't understand what you mean
Protected backup
DROP TABLE IF EXISTS `forum_groups`;
CREATE TABLE `forum_groups` (
`g_id` int(10) unsigned NOT NULL auto_increment,
`g_title` varchar(50) NOT NULL default '',
`g_user_title` varchar(50) default NULL,
INSERT INTO `forum_groups` (`g_id`, `g_title`, `g_user_title`, `g_read_board`, `g_post_replies`, `g_post_topics`, `g_post_polls`, `g_edit_posts`, `g_delete_posts`, `g_delete_topics`, `g_set_title`, `g_search`, `g_search_users`, `g_edit_subjects_interval`, `g_post_flood`, `g_search_flood`) VALUES .....`forum_groups` `g_id`, `g_title`, ext....
Your db backup
DROP TABLE IF EXISTS forum_groups;
CREATE TABLE forum_groups(
g_id int(10) unsigned NOT NULL auto_increment,
g_title varchar(50) NOT NULL,
g_user_title varchar(50),
INSERT INTO forum_groups (g_id, g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES.....that thing prevent the restore table error.
?no
- Connorhd
- Former PunBB Developer
- Offline
Re: [Release] Database Management Plugin
oh, well i dunno but no one has reported any problems so...
Re: [Release] Database Management Plugin
ok
if no return error
is cool
bye
57 2005-04-15 16:36 (edited by klacksa 2005-04-15 16:48)
Re: [Release] Database Management Plugin
lol sorry is again me just a small bug when i restore the db backup
the size of administrator is completly elarge lol
What is this ? :S
have u idea to fix this ?
lol i have fixed the problem for me with just replace the div when return the resulte of backup
i add the div with this -> <div class="postmsg">
?>
<div class="block">
<h2><span>Debug info</span></h2>
<div class="box">
<div class="inbox">
<div class="postmsg">
<p>
<?php
}
$sql_count = count($pieces);
for($i = 0; $i < $sql_count; $i++)
{
$sql = trim($pieces[$i]);
if(!empty($sql))
{
if(defined('PUN_DEBUG'))
{
echo "Executing: $sql\n<br>";
flush();
}
$result = $db->query($sql);
if(!$result)
{
message('Error imported backup file, the database probably has not been restored');
}
}
}
if(defined('PUN_DEBUG'))
{
?>
</p>
</div>
</div>
</div>
</div>
<?phpis ok now bye bye 
Re: [Release] Database Management Plugin
I just downloaded the plugin, I tried different types of backup, and I got an error message: Zero Sized Reply, anyone had the same problem with the plugin, and solved it somehow?
Re: [Release] Database Management Plugin
Does this plugin also recount posts and recheck last post name and date within topics? I am in the process of moving my old self-built forum to PunBB and it would be great to have an automatic reindexer (other than the search reindexer found under Maintenance).
Re: [Release] Database Management Plugin
No
I think you would want this
61 2006-04-09 15:26 (edited by ArchCarrier 2006-04-09 15:30)
Re: [Release] Database Management Plugin
Cool - thanks! Connorhd might want to change the description in the first post of that plugin, because it does a lot more than what it says there!
Re: [Release] Database Management Plugin
one problem with this mod: visitors cant login with their old forum passwords! Plz help, thank you
Re: [Release] Database Management Plugin
Err, what does that have to do with this plugin? 
Re: [Release] Database Management Plugin
one problem with this mod: visitors cant login with their old forum passwords! Plz help! I really don't know what 2 do!!! 
Re: [Release] Database Management Plugin
Read my post and answer
Re: [Release] Database Management Plugin
First of all superb plugin Connorhd. It is a useful tool indeed.
I was able to create dumpfiles using the plugin without any problems.
However, I get the following error when attmepting to restore to a new database using the plugin:
DB Management Error wrote:
No file was uploaed or the upload failed, the database was not restored
I was able to restore using phpmyadmin. But eventually I may need to move to a site where I will not have phpmyadmin access to the database.
Any help would be appreciated.
Version info follows:
PunBB version PunBB 1.2.11
Environment Operating system: Linux
PHP: 5.1.2 - Show info
Accelerator: N/A Database MySQL 5.0.18
Re: [Release] Database Management Plugin
were you trying to upload a file larger than what's allowed to upload?
(in the phpinfo page, check the variables I've mention in the docs for the attachment mod, chapter 1.6, so the uploaded file isn't too large)
Re: [Release] Database Management Plugin
I don't think so. We don't allow attachment uploads to the database (yet) so there are none of those in there. The DB should be pretty small as it's a new site with no more than 500 text only posts.
- Putty
Re: [Release] Database Management Plugin
That's not what I'm talking about, I'm talking about the variables in the PHP settings I've mentioned in the documentation. There's 3 variables that will affect how large files you can send to PHP, and you need to send a file to PHP when reading the dump ...
There's three things that will affect how large files you may allow, everything are PHP settings (the php.ini file).
The most important PHP setting is called "upload_max_filesize" and is default "2M". This value can either be per directory or per system. While you're in the php.ini file, make sure "file_uploads" is "1".
To further complicate things, there's two more things in the php.ini file that needs consideration (and that may not be per folder, so it's global). The settings "post_max_size" must be greater than "upload_max_filesize", and "memory_limit" should be larger than "post_max_size". So it's not just to up one value to handle large files.
check those three settings that I've made bold.
70 2006-07-11 14:39 (edited by KeyDog 2010-02-13 09:44)
Re: [Release] Database Management Plugin
deleted user wrote:
Hello,
My forum www.brokeneden.com/forums/ got hacked by Snakeq3i.
The error it gives is: Unable to fetch user information.I have a backup which i made with the backup plugin i downloaded form the mainpage (called backup not DB manangement).
Becouse it was on the official site i thought this plugin would be good.My problem now is i cant restore it.
When i use the backup in the other plugin (DB manangement) its loading so i waited toll it saud done.
After checking nothing changed, structure hasnt changed and i still dont have posts.
I also tried restoring the backup i had with phpMyadmin but that also wouldnt work...What did i do wrong?
And even more how can i fix my forum?
Thanks,Tim Lolkema
Why the double post?
Looking for a certain modification for your forum? Please take a look here before posting.
Re: [Release] Database Management Plugin
dont werking foor me I dedent see anething
Sorry for my english!
Re: [Release] Database Management Plugin
Hi Connor,
Your code works great, thanks.
Except it prunes all newlines ! Annoying. Do you have any idea ?
Exemple:
xxxx
yyyybecomes
xxxx
yyyyRe: [Release] Database Management Plugin
Er, 'Loading of the plugin 'AP_DB_management.php' failed.'
- Connorhd
- Former PunBB Developer
- Offline
Re: [Release] Database Management Plugin
Try reuploading?
Re: [Release] Database Management Plugin
Really nice plugin. I like it because I missed the functions of it in PunBB 