Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: I want to import my access file's gallery, can friends help me?  (Read 5156 times)

0 Members and 1 Guest are viewing this topic.

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
I want to import my access file's gallery, can friends help me?
« on: October 08, 2008, 08:58:13 am »

I have a site build in microsoft access and asp, now i want to change it to coppermine gallery, is there any good way to do this?

I can write asp code, know a little of php.
right now, my site use iis and also support php.

can somebody help me?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I want to import my access file's gallery, can friends help me?
« Reply #1 on: October 08, 2008, 10:25:36 am »

Not related to plugins, moving accordingly.
Export the Access database, set up coppermine, review the mysql table structure, write an importer in PHP that populates the mysql database with the exported data from your access database. As we have no idea how the structure of your access database is nor what data it contains, we can hardly advice anything, nor can there be a pre-made converter. Basically, you're on your own with this, as this amount of custom coding goes far beyond what you can expect from free support.
If you're actually looking for a paid freelancer to perform that task for you, do as suggested in the sticky thread on the paid help board.
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #2 on: October 09, 2008, 09:16:58 am »

Thank you for your answer.

I tried to write code today, and find something wrong with Coppermine-gallery.
CG's character set is not work very well.
My site's language is Simple-Chinese, When i set a category or album in CG, it's words well, but we i use phpMyAdmin to see to database, it showed like attach below. What's wrong and how can i fix it?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I want to import my access file's gallery, can friends help me?
« Reply #3 on: October 09, 2008, 10:35:23 am »

Convert the textual content of your Access db to utf-8 (unicode) - that's what coppermine is using.
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #4 on: October 10, 2008, 03:47:53 am »

Maybe i used wrong parlance, so you did not undstand my meaning.

first, I do nothing now, and only install coppermine, then I add a new category like below:

category name:我的新分类(in English is my new category)
category description:这是我的一个新的分类,这里是描述!(This is my new category and here is the description)

then, I visited my site, you can see attachment P1, it's words well ,but when i use phpmyadmin(utf-8 mode) to see the database, I saw like attachment P2, It's show me the wrong characters. I use some other phpcms and do not have this problem, it mean that my running environment have no problem. Can you tell me why this happend, is coppermine have some encode problem? I have no idea to solve this problem, and I hope your can help... Thank you very much.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I want to import my access file's gallery, can friends help me?
« Reply #5 on: October 10, 2008, 10:12:04 am »

Reason might be wrong collation for the database or wrong encoding specification in coppermine's config. Post a link to your coppermine gallery for a start.
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #6 on: October 13, 2008, 08:18:53 am »

I think the problem above is ok, last two days, I tried to word as flow:
1. use a program named db2mysql to export access file to a sql file.
2. convert the sql file to utf-8 encode.
3. use phpmyadmin to import this sql file to a temp database
4. write a import php file, here I used the coppermine functions(like:cpg_db_query, add_picture) to finished the action of import, so it woks very well in my localhost computer. (It's also show me the wrong characters when I used phpmyadmin the see the database directly, but it is not important now, In coppermine, all is ok :p. )

but here still a problem i can't figure out.
In my test environment(php4.1) , my code run perfectly, but it's wrong when I ran it on my server(php5.0).
the wrong code is:
Critical error
There was an error while processing a database query

While executing query "INSERT INTO cpg14x_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('6', 'tupian/meinv001/', '200810614204087577801.jpg', '70551', '93505', '650', '865', '1223878521', '1', 'admin','美女圖片攝影--美女.红衣[转载]', '美女圖片攝影--美女.红衣[转载]-1', '美女圖片攝影--美女.红衣转载 美女图片 女人图片下载', 'YES', '', '', '', '', '61.146.42.196', '61.146.42.196', '')" on 0

mySQL error:

File: E:\coppermine-gallery\include\functions.inc.php - Line: 250



USER:
------------------
Array
(
    [ID] => 8bc9661c3c26d94b72cfd52f8040f62b
    [am] => 1
    [lang] =>
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => admin
    [groups] => Array
        (
           
  • => 1

        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [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] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
  • [1] => select * from cpg14x_plugins order by priority asc; (0s)
        [2] => delete from `cpgmm51`.cpg14x_sessions where time<1223874921 and remember=0; (0s)
        [3] => delete from `cpgmm51`.cpg14x_sessions where time<1222668921; (0s)
        [4] => select user_id from `cpgmm51`.cpg14x_sessions where session_id = 'c56eb13bad0916fcf88c8e87cb78a291' (0s)
        [5] => select user_id as id, user_password as password from `cpgmm51`.cpg14x_users where user_id=1 (0s)
        [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `cpgmm51`.cpg14x_users AS u INNER JOIN `cpgmm51`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
        [7] => SELECT user_group_list FROM `cpgmm51`.cpg14x_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 cpg14x_usergroups WHERE group_id in (1) (0s)
        [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
        [10] => update `cpgmm51`.cpg14x_sessions set time='1223878521' where session_id = 'c56eb13bad0916fcf88c8e87cb78a291' (0s)
        [11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
        [12] => DELETE FROM cpg14x_banned WHERE expiry < '2008-10-13 06:15:21' (0s)
        [13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='61.146.42.196' OR ip_addr='61.146.42.196' OR user_id=1) AND brute_force=0 (0s)
        [14] => INSERT INTO cpg14x_albums SET title='美女圖片攝影--美女.红衣[转载]', description='美女圖片攝影--美女.红衣[转载]' , category='2' (0.001s)
        [15] => INSERT INTO cpg14x_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('6', 'tupian/meinv001/', '200810614204087577801.jpg', '70551', '93505', '650', '865', '1223878521', '1', 'admin','美女圖片攝影--美女.红衣[转载]', '美女圖片攝影--美女.红衣[转载]-1', '美女圖片攝影--美女.红衣转载 美女图片 女人图片下载', 'YES', '', '', '', '', '61.146.42.196', '61.146.42.196', '') (0s)
        [16] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
       
[Albums_counts] => 2
    [submit] => Import
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.4 - OK
------------------
mySQL version: 5.0.67-community-nt
------------------
Coppermine version: 1.4.19(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 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 0
Active Links 2
Client API version 5.0.45
==========================
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 | .;C:\php5\pear | .;C:\php5\pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | no value | no value
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 99999999 | 30
max_input_time | 60 | 60
upload_max_filesize | 10M | 10M
post_max_size | 8M | 8M
==========================
Page generated in 0.092 seconds - 17 queries in 0.001 seconds - Album set : ; Meta set: ;



Can you tell me the reason? :( :(
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I want to import my access file's gallery, can friends help me?
« Reply #7 on: October 13, 2008, 08:26:25 am »

Please don't post debug_ouput unless requested. Instead, please answer my questions/requests: post a link to your gallery. Additionally, post what collation you have set for the coppermine tables in your database. That's not a coppermine setting, but is a matter of webserver setup.
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #8 on: October 13, 2008, 09:04:19 am »

I'm sorry!

http://mm.51bofangqi.cn

just install a moment ago.

freshly, and only add one category.
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #9 on: October 13, 2008, 09:10:40 am »

I can't edit my reply, I'm very sorry.

My mysql server use default lan1 character set.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I want to import my access file's gallery, can friends help me?
« Reply #10 on: October 13, 2008, 09:38:34 am »

My mysql server use default lan1 character set.
Huh? What collation have the tables been set to? In phpMyAdmin, after selecting the database in the left frame, take a look at the tables overview: there should be a column named "collation". Take a note of the collation (something like "latin1_languagename_ci") should show up.
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #11 on: October 13, 2008, 09:59:12 am »

 ;D ;D

Its': latin1_swedish_ci

I find this before, and once change it to utf8_general_ci, but not work!
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I want to import my access file's gallery, can friends help me?
« Reply #12 on: October 13, 2008, 10:03:29 am »

Does the textual content look garbled in phpMyAdmin if you browse your records?
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #13 on: October 13, 2008, 10:29:06 am »

In phpmyadmin:  English characters:OK ; Chinese words:Wrong
In coppermine: All are ok!
Just like the pictures I upload before.

I wrote a import rewrite from [[cpg1.4.x]: Adv. Menalto Gallery To Coppermine Converter ], and I used the coppermine's  functions(like:cpg_db_query, add_picture) to finished the action of import, though it shows wrong but it's ok in coppermine. I will retest the Coppermine in my home tonight, I will report it tomorrow.

Now I have another question, In my test environment(php4.1) , my code run perfectly, but it's wrong when I ran it on my server(php5.0):

Critical error
There was an error while processing a database query
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: I want to import my access file's gallery, can friends help me?
« Reply #14 on: October 13, 2008, 12:24:47 pm »

We have a strict "one question per thread" policy that you agreed when signing up, so your second question shouldn't have gone into this thread. The error message
Quote
There was an error while processing a database query
is a generic one. To get details, enable debug_mode in coppermine's config (or, if you can't access the config any longer, do exactly as suggested in the tutorial "Manually enabling debug_mode"). This should give you a more detailed error message that explains what query actually fails.
Logged

maryar

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: I want to import my access file's gallery, can friends help me?
« Reply #15 on: October 13, 2008, 01:27:19 pm »

ok, I will ask that question in Mods: Convertors, sorry.

Although this problem is not trouble me , but I think there must be something not work very well, I test in my home, and now, give you some pictures, hope it's helpful.

1. mysql:Attach1,

2. after install:Attach2, phpmyadmin screen view.

when I add new category, it also like I had attached before.

Thank you very much for your answers.
Logged
Pages: [1]   Go Up
 

Page created in 0.031 seconds with 20 queries.