17452 Posts in 4473 Topics by 1971 members
|Go to End|
4 December 2008 at 5:53am Last edited: 4 December 2008 5:58am
i was supposed to import (from postgres db) some objects and images to SS. I did it and objects (hotels) work fine, but i have problem with images, they work fine till someone goes into 'Files and images' in CMS, after that records withy imported images in mysql database disappear.
I guess that i imported data and inserted them not to all required table.
What i did (in each step):
INSERT INTO File(ID,ClassName,Name,Title,Filename,ParentID,OwnerID) VALUES($actNumber,'Image','".$name1Got."','".$name1Got."','assets/".$rowP['photo1']."',8,1)
(at the end values 8 and 1, because i found out that cms automatically gives that values to that files)
UPDATE HotelSPA_Live SET Photo1ID = ".$actNumber." WHERE ID = ".$got['ID']."
UPDATE HotelSPA SET Photo1ID = ".$actNumber." WHERE ID = ".$got['ID']."
same thing for another 5 photos and then another step for another object
and as I said: works fine till somone goes into 'photo and files' in cms and (not sure that) when somone adds images in cms (from right menu).
I see that photos are loaded in cms (got option for delete or replace), but i don't see them, 'cause they're not in database (let's say objects had ID from 300 to 500, now new Id starts from 501)
What should I do to avoid that king of problem ?
|Go to Top|