One other things is that when i go to the manage part of the dump files i see the list of dumps i made and a word behind, it says Supprimer. I assume it says delete in some language. It is hardcoded into gest.php with no reference to a language file tag.oups! i have forgotten to change this :-[
USER:
------------------
Array
(
[ID] => d6d317e8ccae72da826b565b89013be4
[am] => 1
[lang] => english
[liv] => Array
(
[0] => 518
[1] => 517
[2] => 521
[3] => 7
[4] => 10
)
[sort] => da
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => Hein
[groups] => Array
(
[0] => 1
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 1
[ufc_min] => 1
[custom_user_upload] => 0
[num_file_upload] => 10
[num_URI_upload] => 0
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[upload_form_config] => 1
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content, player FROM cpg1410_filetypes; (0s)
[1] => select * from cpg1410_plugins order by priority asc; (0s)
[2] => delete from `*******`.cpg1410_sessions where time<1173450536 and remember=0; (0.002s)
[3] => delete from `*******`.cpg1410_sessions where time<1172244536; (0s)
[4] => select user_id from `*******`.cpg1410_sessions where session_id=md5("d2e7e3bed121f70f8aae2d495f845d7a1c469836f9164ac982aad2272b5d9de8"); (0s)
[5] => select user_id as id, user_password as password from `*******`.cpg1410_users where user_id=1 (0s)
[6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `*******`.cpg1410_users AS u INNER JOIN `*******`.cpg1410_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
[7] => SELECT user_group_list FROM `*******`.cpg1410_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
[8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM cpg1410_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg1410_usergroups WHERE group_id= 1 (0s)
[10] => update `*******`.cpg1410_sessions set time='1173454136' where session_id=md5('d2e7e3bed121f70f8aae2d495f845d7a1c469836f9164ac982aad2272b5d9de8'); (0s)
[11] => SELECT user_favpics FROM cpg1410_favpics WHERE user_id = 1 (0.001s)
[12] => SELECT home,login,my_gallery,upload_pic,album_list,lastup,lastcom,topn,toprated,favpics,search FROM cpg1410_final_extract_config WHERE Group_Id=1 (0s)
[13] => SHOW TABLES LIKE 'cpg1410_cms_config' (0.002s)
[14] => SELECT * FROM cpg1410_cms_config (0s)
[15] => SELECT count(*) FROM cpg1410_pms WHERE owner=1 (0.001s)
[16] => SELECT count(*) FROM cpg1410_pms WHERE owner=1 AND showed='0' (0s)
[17] => SELECT count(*) FROM cpg1410_buddy WHERE user_id=1 (0s)
[18] => SELECT count(*) FROM cpg1410_buddy_req WHERE buddy_to=1 (0s)
[19] => DELETE FROM cpg1410_banned WHERE expiry < '2007-03-09 15:28:56' (0s)
[20] => SELECT * FROM cpg1410_banned WHERE (ip_addr='81.69.50.110' OR ip_addr='81.69.50.110' OR user_id=1) AND brute_force=0 (0s)
)
==========================
GET :
------------------
Array
(
[file] => backup/backup
)
==========================
POST :
------------------
Array
(
[act] => dodump
[dbhost] => localhost
[dbbase] => *******
[dbuser] => *******
[dbpass] => **********
[LastTable] => -1
[LastRow] => -1
[selc] => on
[tbls] => Array
(
[0] => cpg1410_albums
[1] => cpg1410_banned
[2] => cpg1410_bridge
[3] => cpg1410_buddy
[4] => cpg1410_buddy_req
[5] => cpg1410_categories
[6] => cpg1410_cms
[7] => cpg1410_cms_config
[8] => cpg1410_comments
[9] => cpg1410_config
[10] => cpg1410_dict
[11] => cpg1410_ecards
[12] => cpg1410_exif
[13] => cpg1410_favpics
[14] => cpg1410_filetypes
[15] => cpg1410_final_extract_config
[16] => cpg1410_hit_stats
[17] => cpg1410_notify
[18] => cpg1410_pictures
[19] => cpg1410_plugins
[20] => cpg1410_pms
[21] => cpg1410_sessions
[22] => cpg1410_temp_data
[23] => cpg1410_usergroups
[24] => cpg1410_users
[25] => cpg1410_vote_stats
[26] => cpg1410_votes
)
[SaveStruct] => 1
[SaveData] => 1
[ChkDropTable] => 1
[ChckIfNotExists] => 1
[FileName] => dump_*******_20070309
)
==========================
VERSION INFO :
------------------
PHP version: 5.1.6-pl6-gentoo - OK
------------------
mySQL version: 4.1.21-log
------------------
Coppermine version: 1.4.10 modpack v1(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support: 1
JIS-mapped Japanese Font Support:
==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 5
Active Links 6
Client API version 4.1.21
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/share/php5:/usr/share/php | .:/usr/share/php5:/usr/share/php
open_basedir | /kill-9.be/users/hop:/tmp/:/usr/share/php/:/usr/lib/php/ | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 4M | 4M
post_max_size | 8M | 8M
==========================
Page generated in 0.13 seconds - 21 queries in 0.006 seconds - Album set : ; Meta set: ;
Installed - tested and works like a charm ! AFAIK the experimental can be removed 8)
Hein (Dutch transl) : the button in the first screen of this mod states "connect" as title - maybe change it to "uitvoeren" oid in the dutch language file ?!?
I updated the dutch.php a bit and added it to this post.
Hein
Click for select all teh tables
Click to select all tables
definitely not experimental ... i just installed it and backed up my database, no problems!!! Sourire SouriantI'm happy for you ;)
Will this backup onely cpg1410_ prefix or whole databaseYou can choose the tables you want to backup
Frantz.. when is the experimental bit going to be erased from the plugin name ? I think it has proven itself by now ;)
Did you see my post above?yes !
Clearly, there are still problems with this plug-in, as my experience showsas i said befor, i know that the plugin don't work correctly on some intallations.
...i know that the plugin don't work correctly on some intallations.
ERROR !did you try with one or two selected tables ?
No table selected. You have to select at least one table.
This error occurs even when I have selected all the tables:
Click for select all teh tables
I really don't understand why the experts around here are so unfriendly.Hein is'nt unfriendly, he just explain why you don't have a response at your problem
That might indicate an issue. Maybe I need to re-install this and try again?Yes it's a good idea
@Frantz: please don't replace the version in the initial posting yet - let's test this version first thoroughly.OK
@Frantz: could you please contact the original author once more and ask for permission to bundle it with cpg1.5.x? Thanks in advance.I will see if i can find the email adress from the original author. I let you know the answer...
I developed my improvements on my cpg1.5.x testbed, so the plugin should already be ready to run with the future versionHey good news ;)
That's why I plan to implement a standalone file for restoring the dumpYes, surelly a good idea for newbies and for other users ;D
;) you guessed right, what you are asking is not ment for this thread. I can't do anything within the plugin contributions part of the board otherwise i would have moved it to here http://forum.coppermine-gallery.net/index.php?board=47.0 (http://forum.coppermine-gallery.net/index.php?board=47.0)Maybe someone else can move it ? Or indicate i should really open a new thread ::) ;)
But this might be something you can use, it's the CPG live demoI saw that one - as stated in the descr. it is not a real installation so i imagine a plugin install is not be possible at least not desirable !
I am not sure if you can run plugins in that demo as wel.Sure you can - the live demo is a full apache webserver. In fact my development system is based on the live demo (it's portable, I can take it with me on a stick).
Sure you can - the live demo is a full apache webserver. In fact my development system is based on the live demo (it's portable, I can take it with me on a stick).
Query Error Line 109
Error :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '23:42:13,NULL,NULL)' at line 1
INSERT INTO `cpg132_cms` VALUES(1,0,'Willkommen bei Velvet Photos','<p>Schickt mir Euer Feedback und Eure Anregungen - nutzt das <a href="http:\/\/www.velvet-photos.de/kontakt.php">Kontakt-Formular</a>. Es werden bald neue Fotos hier erscheinen. Schaut immer mal wieder vorbei.</p>',0,0,2007-04-14 23:42:13,NULL,NULL);
Query Error Line 110
Error :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '16:31:28,NULL,NULL)' at line 1
INSERT INTO `cpg132_cms` VALUES(4,11,'Lautenfestival - Ein zusätzlicher Hinweis','Die Bands Asfur und IOCULATORES traten im Rahmen dieses Festivals auf - die Fotos dazu finden Sie hier und in der Kategorie Konzertfotos, dann unter dem Namen der jeweiligen Band.',1,1,2007-03-14 16:31:28,NULL,NULL);
Query Error Line 111
Error :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '21:55:18,NULL,NULL)' at line 1
INSERT INTO `cpg132_cms` VALUES(5,0,'test2','Test2',1,3,2007-01-01 21:55:18,NULL,NULL);
if ($type == 'tinyint' || $type == 'smallint' || $type == 'mediumint' ||
$type == 'int' || $type == 'bigint' ||$type == 'timestamp')
But if reachable from public internet then a password questioning is needed - to prevent the everybody from restore my db to an old versionYou mean an extra check besides the fact that user is Admin ? If so - i second this request !
But if reachable from public internet then a password questioning is needed - to prevent the everybody from restore my db to an old version
You mean an extra check besides the fact that user is Admin ? If so - i second this request !And what password are you going to check? Coppermine's admin password that is being stored in the database? Obviously not, as you're trying to restore a crashed database, so you can't check for the admin password.
I'm not sure though if this will go into the plugin (because I'm not sure how to accomplish this permissions-wise)In my opinion I have the following options to accomplish authentification:
An extra BackupRestore.php for restores with corrupt db's or PlugInConfigs is very helpfull - i hope next version come with this.I doubt that the next version will contain a standalone restore - I already said so:
I'm not sure though [...] when I will have the time to look into this, so don't expect such a file in the near future.You're welcome to come up with a suggestion if you have the time.
Testing - in Select table to process form i saw that my Table Prefix is cpg1410 but my release is 1412 - oopsie - whats going on :o :o Checked - contra checked - read dump php files - checked again - pfoe.As suggested in the thread you refered to: the prefix is just a name that you deliberately chose when installing Coppermine in the first place. Yours is a PEBCAK issue, sorry. Your remark is in no way related to this thread. Please keep the discussion about the table prefix to the thread you refered to - don't cross-post.
At last i found out :
Nothing to be concerned about : See thread - http://forum.coppermine-gallery.net/index.php?topic=45230.0 - table prefix is not updated to 1412 - works as designed !
Thought is was best to put it here before anyone else stumbles upon this ;)
You're welcome to come up with a suggestion if you have the time.To come with suggestions - I do my very best ;)
Maybe better to use the phpmyadmin or other tools to make this on serverside
Will coppermine add this as standard to their software as it was always an option that I felt was missing from the main package.This is currently being discussed on the dev-only board. My vote is "yes".
My vote is yes too.Cpg1.5.x development should not be discussed further within this thread!
But with the extension of a separate php site (password protected) for restore in worstcase, if db corrupted and admin page don't work.That's what I already have pointed out - see
Things that are left to do: backing up your database is important and can be achieved using this plugin. However, if the database is broken and needs to be restored from a backup, the coppermine user interface might be broken as well. Subsequently, newbies can't restore the database using the plugin (which requires the coppermine user interface to be up). That's why I plan to implement a standalone file for restoring the dump. I'm not sure though if this will go into the plugin (because I'm not sure how to accomplish this permissions-wise) nor when I will have the time to look into this, so don't expect such a file in the near future.
INSERT INTO `smf_log_online`
VALUES (
'gga9hpcbmfus5ctfv15srum312', 2007 -11 -2322 :15 :49, 1, 1378420331, 'a:1:{s:10:\"USER_AGENT\";s:89:\"Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)\";}'
);
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '22:15:49,1,1378420331,'a:1:{s:10:\"USER_AGENT\";s:89:\"Mozilla/4.0 (compatible; ' at line 1
Using v2.1 (as well as the plugin in the first post) I get this error...
ERROR !
No table selected. You have to select at least one table.
It was mentioned earlier in the thread, but nothing ever came of it. My site is hosted on PowWeb and I've not ran into any restrictions with mySQLadmin (but I'm a newbie at it). My Coppermine is bridged with Joomla and I'm thinking that is the source of the issue... as it is with most plugins in a bridged environment. Just thought I'd report this.
You probably need to add $CONFIG['LINK_ID'] to all the mysql_* calls for bridge compatibility.
Hello,The latest version of this plugin is 2.3. You're right, i attach this version to the first post.
I wonder what the latest version of this plugin is. GauGau has this: cpg1.4.x_plugin_backup_2.3.zip in his latest post. Is this the latest and is it the same as the one in the original post? If possible, kindly include the latest in the first post, to avoid confusion. Thanks.
Cornelio
The latest version of this plugin is 2.3. You're right, i attach this version to the first post.