2.2.9 -> 3.2-4 Another Import Problem (image/article linking)

Friday 13 February 2004 1:53:11 pm

I've finally got all of my files, images, users and articles imported into 3.2 but I can't get the linking working correctly between articles and the images. Has anyone else had this problem and more importantly does anyone have a solution.

I can see the images inside the image folder and I can see the links in ezcontentobject_link beween the images and the articles. If I add a new image via image upload it works.

Thanks,
Ken Colwell

Saturday 14 February 2004 10:25:01 am

Hi,

Yes I did the import in the correct order: folders, images, articles

Old article: http://www.muc.edu/article/articleview/4280/1/139/
New article: http://test2admin.muc.edu/content/view/full/10753
Click the edit button and the url becomes: http://test2admin.muc.edu/content/edit/10232/2/
The object tag is in the article: <object id="5701" size="medium" align="right" />
But nothing is listed in the right "related objects" box

Perhaps the problem is the article object ID which seems to change from 10753 to 10232 when I click edit?

In ezcontentobject_link table I have the following:

select * from ezcontentobject_link where to_contentobject_id=5701
+------+-----------------------+----------------------------+---------------------+
| id | from_contentobject_id | from_contentobject_version | to_contentobject_id |
+------+-----------------------+----------------------------+---------------------+
| 1770 | 10232 | 1 | 5701 |
+------+-----------------------+----------------------------+---------------------+

also from ezcontentobject:

select * from ezcontentobject where id=10753;
Empty set (0.00 sec)

select * from ezcontentobject where id=10232;
+-------+----------+------------+-----------------+----------------------------------------------------------------------------------+-----------------+--------------+------------+------------+--------+----------------------+
| id | owner_id | section_id | contentclass_id | name | current_version | is_published | published | modified | status | remote_id |
+-------+----------+------------+-----------------+----------------------------------------------------------------------------------+-----------------+--------------+------------+------------+--------+----------------------+
| 10232 | 46 | 0 | 2 | Dr. Robert D. Ballard, Deep Sea Explorer of Titanic, to Present Schooler Lecture | 1 | 0 | 1074117591 | 1074117591 | 0 | article_article_4280 |
+-------+----------+------------+-----------------+----------------------------------------------------------------------------------+-----------------+--------------+------------+------------+--------+----------------------+

New images work great and the imported images don't appear in the articles in the admin section or the user site. the imported images are viewable by going to the images folder in the administration system.

Thanks for your help,
Ken Colwell

Saturday 14 February 2004 7:48:03 pm

Hi Marco

Thanks for explaining the number change. If you would like to login and take a look for yourself send me an email to colwelkg@muc.edu and I will send you the login information.

My ezimage table has the following entries:

select * from ezimage where alternative_text like "%ballard%";
+----------------------------+---------+---------------+--------------------+------------+-----------------------+
| contentobject_attribute_id | version | filename | original_filename | mime_type | alternative_text |
+----------------------------+---------+---------------+--------------------+------------+-----------------------+
| 16485 | 1 | phpCwXjCZ.jpg | robert ballard.jpg | image/jpeg | Dr. Robert D. Ballard |
| 16755 | 1 | phpeaquCu.jpg | ballard.jpg | image/jpeg | Dr. Robert D. Ballard |
| 16485 | 2 | phpCwXjCZ.jpg | robert ballard.jpg | image/jpeg | Dr. Robert D. Ballard |
+----------------------------+---------+---------------+--------------------+------------+-----------------------+

select * from ezimagevariation where contentobject_attribute_id like 16485 or contentobject_attribute_id like 16755 or contentobject_attribute_id like 16485;
+----------------------------+---------+-----------------------------+-----------------+-----------------+------------------+-------+--------+
| contentobject_attribute_id | version | filename | additional_path | requested_width | requested_height | width | height |
+----------------------------+---------+-----------------------------+-----------------+-----------------+------------------+-------+--------+
| 16485 | 2 | phpCwXjCZ_100x100_16485.jpg | p/h/p | 100 | 100 | 84 | 100 |
+----------------------------+---------+-----------------------------+-----------------+-----------------+------------------+-------+--------+
1

select * from ezcontentobject_attribute where contentobject_id like 5701;
+-------+---------------+---------+------------------+--------------------------+----------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------+--------------+-----------------+
| id | language_code | version | contentobject_id | contentclassattribute_id | data_text | data_int | data_float | attribute_original_id | sort_key_int | sort_key_string |
+-------+---------------+---------+------------------+--------------------------+----------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------+--------------+-----------------+
| 16483 | eng-US | 1 | 5701 | 116 | | 0 | 0 | 0 | 0 | |
| 16484 | eng-US | 1 | 5701 | 117 | <?xml version="1.0" encoding="UTF-8"?>
<section>
<paragraph>Dr. Robert D. Ballard</paragraph>
<paragraph />
</section> | 1045487555 | 0 | 0 | 0 | |
| 16485 | eng-US | 1 | 5701 | 118 | | 0 | 0 | 0 | 0 | |
| 16483 | eng-US | 2 | 5701 | 116 | | 0 | 0 | 0 | 0 | |
| 16484 | eng-US | 2 | 5701 | 117 | <?xml version="1.0" encoding="UTF-8"?>
<section>
<paragraph>Dr. Robert D. Ballard</paragraph>
<paragraph />
</section> | 1045487555 | 0 | 0 | 0 | |
| 16485 | eng-US | 2 | 5701 | 118 | | 0 | 0 | 0 | 0 | |
+-------+---------------+---------+------------------+--------------------------+----------------------------------------------------------------------------------------------------------------------------+------------+------------+-----------------------+--------------+-----------------+

All of this seems logical, I'm not really seeing anything wrong? Any ideas?

thanks,
ken colwell

Tuesday 17 February 2004 8:14:05 am

Hello,

I did a table by table comparison between one of the images that had been edited and one of the images that didn't work and the only difference that I found was the status field in the ezcontentobject table. All of my imported images had there status field set to 0. Once the status is changed to 1 all of the images appear in the articles on both the user and admin sites.

mysql> update ezcontentobject set status="1" where contentclass_id = "5";

Special thanks to Marco for taking a look at my site and helping me narrow the list of potential problems.

Thanks,

Ken Colwell