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();

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.

Re: [Release] Database Management Plugin

sorry i don't understand what you mean hmm

54 (edited by klacksa 2005-04-15 16:32)

Re: [Release] Database Management Plugin

Connorhd wrote:

sorry i don't understand what you mean hmm

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

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 (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>
<?php

is ok now bye bye wink

58

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 (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!

62

Re: [Release] Database Management Plugin

one problem with this mod: visitors cant login with their old forum passwords! Plz help, thank you wink

Re: [Release] Database Management Plugin

Err, what does that have to do with this plugin? tongue

64

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!!! sad

Re: [Release] Database Management Plugin

Read my post and answer tongue

66

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)

68

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 (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


yyyy

becomes

xxxx
yyyy

73

Re: [Release] Database Management Plugin

Er, 'Loading of the plugin 'AP_DB_management.php' failed.'

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 smile