I want to import my access file's gallery, can friends help me?

[maryar]

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?

[Joachim Müller]

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.

[maryar]

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?

[Joachim Müller]

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

[maryar]

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.

[Joachim Müller]

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.

[maryar]

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?

[Joachim Müller]

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.

[maryar]

I'm sorry!

http://mm.51bofangqi.cn

just install a moment ago.

freshly, and only add one category.

[maryar]

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

My mysql server use default lan1 character set.

[Joachim Müller]

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.

[maryar]

 

Its': latin1_swedish_ci

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

[Joachim Müller]

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

[maryar]

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

[Joachim Müller]

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

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.

[maryar]

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.