By freespirit on

Hello, I have copied image and img_assist modul on my site and enabled them in modules section. However, when I wanted to add an image image don't show and neither thumbnail. When I wanted to insert image in my content using img_assist icon below the Body box I got this error message:

user error: Table 'srol_drpl1.img_assist_map' doesn't exist
query: DELETE FROM img_assist_map WHERE nid = 29 in /home/srol/public_html/site/includes/database.mysql.inc on line 66.

user error: Table 'srol_drpl1.img_assist_map' doesn't exist
query: INSERT INTO img_assist_map (nid, iid) VALUES(29, 2) in /home/srol/public_html/site/includes/database.mysql.inc on line 66.

warning: Cannot modify header information - headers already sent by (output started at /home/srol/public_html/site/includes/com

Can someone know the solution of this problem? How can I add photos in my posts and how can I align them?

Thank you very much!

Comments

heine’s picture

heine commented

img_assist needs its own database table. To create this table execute the query in the mysql file (included in the img_assist archive) (eg 'import' in phpmyadmin).

Make sure you also read the INSTALL.txt file that comes with img_assist.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

freespirit’s picture

freespirit commented

Thanks for replying. After your post I tried to do that but still the same.

Also, when I want to upload photo using image module (there is no instalation) instead of thumbnail and photo I get the text with the link and when I click there is no photo. Also, there is no photo on Image Gallery menu. I want to tell that my hosting supports Image Magick.

Speaking about your img_assist module I went to my cPanel and clicked on MySQL databases. I want to tell you that I'm not tech savvy, I haven't done with this before.

When I clicked on MySQL Databases there were several databases. Then I clicked on phpmyadmin, chose drupal database called srol_drpl1 clicked on SQL Query icon, imported img_assist.mysql and got successful message. Before that there were 55 tables in database and after that 56.

However I STILL can't upload images! Now I don't get error message but when I click on Img assist icon below Body box and want to upload photo but there are no images shown after I click submit! Also, they are not shown on the content page.

Does anyone know the solution? Does it matter if I imported img_assist.mysql from my computer and not form web?

I will really appreciate if anyone solve this.

heine’s picture

heine commented

Hi freespirit,

The situation is no longer the same, because you don't get the missing table anymore. Granted, the outcome is still the same, but we have one problem less to deal with.

Can you tell me something about the filetype (extension eg .jpg) and the size of the picture you are trying to upload?
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

freespirit’s picture

freespirit commented

I tried with .gif and .jpg with smaller and larger photos and it is the same thing. If I wouldn't have Coppermine on my other domain that requires ImageMagick I would have thought that my reseller hosting doesn't have ImageMagick but I know it has.

Images are not shown in my pop-up box for image upload, there are only some vertical blue lines instead of photos. Also, I can't use Image module either.

solipsist’s picture

solipsist commented

img_assist worked perfectly fine before I moved my site to a new host. They have GDLib installed, as for ImageMagick, I do not know. The files are uploaded and resized but drupal can't find them.

A path like
/system/files/?file=images/abcdefg_1.jpg

throws a "not found" at me, all the time tho I know the files are there!

The files folder and all subfolders are CHMODed 777 just to be sure but it makes no difference.

EDIT: Okay, I set file access to public and it suddenly works. There seems to be a problem with Drupal's file handling. Any idea what it might be?

--
Jakob Persson - blog
Leancept – Digital effect and innovation agency

Willy Smith’s picture

Willy Smith commented

I had two problems which were easily fixed:

1) I had to create the tables manually in phpmyadmin since my provider doesn't allow an import script. In the Drupal database for your installation, create a new table called img_assist_map with two fields. Then click go. Then manually enter the values shown in the img_assist.mysql file (in the .tar). When you're done with this, phpmyadmin shows the script which should match what's in the orginal file. Note that if you make a mistake, you can delete the table and create it again.

2) Once I had done this, I followed the instructions in the INSTALL.txt file. No images appeared, but I could see that they had been uploaded into the files/images/ directory. I fixed this by changing the permissions for the files/images directory. Since I only have FTP access to my provider, I did this via my browser (Konqueror): Enter the /files directory, right-click on the ./images directory and bring up the properties menu. Click on "Permissions" and enable "Enter". In my case, the permissions were set correctly for the individual image files but NOT for the subdirectory, so Drupal logged a 403 error when the image was accessed.

Although these are instructions for my specific provider and OS, it should be applicable to other situations. The basic site setup was done with Fantastico, which doesn't have scripts to add additional Drupal modules.