Map of orders

Hi there,When you process the images it should say something like:Please wait.. Processing the Grid image with GDSaved as /srv/www/htdocs/mds/admin/temp/temp1.gifThen if you look at that image it should be what your grid should look like when you call it with the Grid HTML code it gives you. You can get this by clicking Get HTML Code or by going to /admin/gethtml.php and copying the Grid HTML.You may have to clear your browser cache or refresh the page for it to show up.Hope this helps =)Ryan

Thanks for your quick reply. With Get HTML Code i see the grid with my uploaded pictures. But when i go at a map of orders i dont see her at all, even i clean up cookies of my browser. When i try to see background code of a grid picture i get the message: Fatal error: Allowed memory size of 12582912 bytes exhausted (tried to allocate 1000 bytes) in /home/mysite/public_html/admin/show_map.php on line 49My grid width and height are not changed. (100x100)Block size is 10x10 in pixelsWhat should be the problem now?Thanks again!

It sounds like PHP is using up all its allocated memory.In the admin area try going to Configuration > Main Config and setting the Memory Limit higher. If this doesn't work then you might try asking your host to raise the limit in your PHP config, but often they will not be able to do this unless you are on a dedicated server.

Thanks for your advice with showing a map. It sure helped me out with increase the memory to 16 MB. B) I have another problem showing in Orders Deleted. When i try to see the certain deleted order the following message shows: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and t1.banner_id='' and t1.ad_id='' AND t1.order_id=t2.order_id' at line 1I`m not sure where exactly i have to write this, in mysql database.I will be very grateful if you can help me with this too. :)

Hi there,This sounds like it may be a bug.Could you please login and submit a bug to the brand new bug tracker I just set up and see if it works out for you.Here is the URL:https://milliondollarscript.com/component/option,com_flyspray/Itemid,70/This will help me keep track of bugs like this easier so I can track them down and fix them. If you can include the steps you took so I can reproduce this error then I can probably fix it.Thanks :)Ryan

Hi Admin,Ive installed krishanadmin trough FTP in my admin folder of my site, and follow the instructions of login, but that did not solve my problem. I dont know where to report this bug. Should i leave on you now, or i have to do something about that? Now im complete lost in space :dry: I still count on you.Cheers!

Can you tell me what URL you click when you get this error? All I need is the part after the domain such as /admin/ads.php?ad_id=1&order_id=3&banner_id=1

Sure, problem appears in Advertiser Admin -> Orders:Deleted in AdID column of grid where deleted orders shows. URL of that link is: /admin/ads.php?ad_id=10&order_id-10&banner_id=1The same problem for every link of my deleted order.Again message i get is like broken link in the same page of admin_html which says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and t1.banner_id='' and t1.ad_id='' AND t1.order_id=t2.order_id' at line 1Many Thanks :cheer:

Is it order_id-10 or order_id=10? I am not sure if that would be a problem or not but if its -10 that might be a place for me to start looking for the problem.I looked at the SQL query and it seems fine. It works on my system fine. In fact when I click that link it says: Either the user id for this ad doesn't exist or this ad doesn't exist.So you shouldn't really have to click that link anyway by the looks of it.

My mistake, It is order_id=10; NOT order_id-10; Anyway i will try to look up in my sql data base again. It is strange that this problem appears only in my orders: Deleted, but not in Orders: Canceled, or Orders: Expired.That might be some good sign that my sql works fine. Thanks anyway! :)

There is probably a bug some place. I will see if I can find it and fix it.

Did you modify your form?

I`ve tried, but no sucsess yet. In db structure everuthing seems to work fine.

So you tried to modify your form? I am talking about the form you can modify in the admin area under Configuration > Ad Form. Did you modify this form by any chance?

I just programmed a script to fix the file permissions on my trac on a cron job. So that you can download it again properly and test out the latest and see if that fixes your problem.https://milliondollarscript.com/trac/changeset/26/branches/2.1

Hi, Admiin,Yes, this solved my problem properly. I`m happy for using this script and for the successfull cooperation with you.Thanks a lot.Best wishes! :cheer:

Oh great! Glad to hear it is working for you.If you have any more troubles feel free to submit a bug report or feature request any time and I will see what I can do to help.Ryan