Wishlist 0 ¥0.00

1052 - Column 'title' in where clause is ambiguous

Hello world:) i need help.....
1052 - Column 'title' in where clause is ambiguous
when I use the search component, this message appears.
until two months ago it worked fine
Can someone help me?
thanks
t.Mariateresa
 
User avatar
garkell
Joomla! Apprentice
Joomla! Apprentice
Posts: 41
Joined: Mon Aug 31, 2009 9:32 pm
Location: Australia
Contact:

Re: 1052 - Column 'title' in where clause is ambiguous

Post by garkell » Mon Sep 11, 2017 1:01 am

Hi toybel,
This is because the where clause in the SQL statement is using a field called "title" and the complete SQL statement has more than one field with that name.
I'm guessing you are using a component/module/plugin with a search function?
What is it? You will probably need to go back to the author of the product being used. Cheers.
Glenn
 
toybel
Joomla! Apprentice
Joomla! Apprentice
Posts: 14
Joined: Tue Mar 13, 2007 9:50 am

Re: 1052 - Column 'title' in where clause is ambiguous

Post by toybel » Mon Sep 11, 2017 9:49 am

thanks for answer:)))
the extension rialto cause conflict with joomla component search

IPv6简介

IPv6作为下一代互联网的网络层协议,用它来取代IPv4主要是为了解决IPv4地址枯竭问题,同时它也在其他方面对于IPv4有许多改进。

现今的互联网络发展蓬勃,截至2018年1月,全球上网人数已达40.21亿,IPv4仅能提供约42.9亿个IP位置。虽然当前的网络地址转换及无类别域间路由等技术可延缓网络位置匮乏之现象,但为求解决根本问题,从1990年开始,互联网工程工作小组开始规划IPv4的下一代协议,并于1996年8月10日成为IETF的草案标准,最终IPv6在1998年12月由互联网工程工作小组以互联网标准规范(RFC 2460)的方式正式公布。

IPv6的计划是创建未来互联网扩展的基础,IPv6具有比IPv4大得多的编码地址空间。这是因为RFC 2373和RFC 2374定义的IPv6采用128位的二进制地址,而IPv4使用的是32位二进制。因此新增的地址空间支持2128(约3.4×1038)个地址,具体数量为340,282,366,920,938,463,463,374,607,431,768,211,456个,也可以说成1632个,因为32位地址每位可以取16个不同的值。

以地球人口70亿人计算,每人平均可分得约4.86×1028(486117667×1020)个IPv6地址。

IPv6地址的表达形式一般采用32个十六进制数。例如:2001:0db8:85a3:08d3:1319:8a2e:0370:7344是一个全局唯一的IPv6地址

Minifrontpage error: 0 - The image file does not exist.

I installed the module.
It all worked good, but on every article there was a default image.

So I added some pictures in my news-articles.
Although, the thumbnails stayed the same.
I tried to remove the default images with FTP from the folder /images/thumbnails/mod_minifrontpage

This resulted in the error that I have a fully blank page, only with the error "0 - The image file does not exist."
I have to disable the module, to see my website again.

Uninstalling and re-installing still gives me the same error

greetings
Seppe
 
 
Resolved

Accepted Answer

  •  
    Replied by admin on Monday, April 13 2020, 03:53 PM
    I think I found the reason of the error. It looks like the module doesn't work properly with image that contains spacing in its file name. It happens when you add the image directly using the wysiwyg editor, but it works properly when you use Intro image or Full Article Image to add image to the article.
    I'll try to fix it, but temporarily, if you want to to add image directly from editor, please remove spacing in the your image filename first.

     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
 
 
31 responses Add Yours

                               

  •  
     
    Replied by admin on Monday, April 13 2020, 01:54 PM · Hide· #1
    Could you let me know the URL of your site so I can take a look?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:01 PM · Hide· #2
    I have created a superuser account for you
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:02 PM · Hide· #3
    Can you point me to the page where you publish the module?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:17 PM · Hide· #4
    the forntpage. it should be above the yellow banner

    but when "published" the whole site is gone
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:20 PM · Hide· #5
    Everything worked in the beginning.
    But I did the stupid thing to remove the thumbnails, hoping I could use my own
    since then, it crashes
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:23 PM · Hide· #6
    Ah I see. Can you check this folder manually (using ftp) :
    1
    /images/thumbnails/mod_minifrontpage
    if it doesn't exist, try to create it manually
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:25 PM · Hide· #7
    the folder exists
    already from the beginning of the installation. (see my opening post)

    I removed all the .jpg's inside of it.
    then it went wrong
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:30 PM · Hide· #8
    Hmm strange. Is it possible for you to provide a temporary ftp access ?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:31 PM · Hide· #9
    yes, I will create in a second

    yes, it's very strange.
    It worked with the default installation
    but even uninstalling and re-installing to have the default again doesn't work
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:38 PM · Hide· #10
    did you receive the FTP details?
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 02:44 PM · Hide· #11
    No, how did you add it? Simply add it using the Your site details tab below
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:45 PM · Hide· #12
    yes, I did that
    like I sended all the super-user details
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:46 PM · Hide· #13
    here it is again for the FTP
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 02:58 PM · Hide· #14
    When you enable the module, I now get:
    * plenty errors on my screen
    * in the admin-panel the text is resized
    * the textboxes are a lot smaller

    more and more modules and plugins are giving errors

    so I guess the best thing is to uninstall everything :)
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:01 PM · Hide· #15
    aha

    there he is again :)
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 03:06 PM · Hide· #16
    When you enable the module, I now get:
    * plenty errors on my screen
    * in the admin-panel the text is resized
    * the textboxes are a lot smaller

    more and more modules and plugins are giving errors

    so I guess the best thing is to uninstall everything :)

    It because I changed the Error Reporting in the Global Configuration to Development level, to see the actual error message and you have some notice and deprecated message with plugins you have installed (bye bye generator and google analytics). I have switched it back the Error reporting to System Default to hide the notice messages.

    I have deleted the folder /images/thumbnails/mod_minifrontpage manually using ftp, then reinstalling the module. It looks like the module run properly now. Please have a look
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:08 PM · Hide· #17
    It worked for a second
    It had the default settings. I had 5 news-blocks.

    I changed it like I had it in the beginning, and there is the error again.....
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:10 PM · Hide· #18
    when you change the "number of articles to show" from 5 to for example 12

    I want a grid of 4 x 3
    then it crashes again

    which he didn't do in the beginning
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:13 PM · Hide· #19
    9 is now the maxium number of articles I can show
    I tried through FTP to add 12 thumbnails in total, but that doesn't work

    10 articles to show or above makes the plugin crash
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 03:17 PM · Hide· #20
    I think there's something wrong with the 12th articles. When I set the category to Nieuws Algement with article = 12, it show 1 item and didn't returned an error. Can you check what is the 12th articles and also can you try to add more articles?
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:20 PM · Hide· #21
    there are 12 articles to create the grid
    there are 3 different categories

    I added them all to the module

    the module is completly set now

    Only the number of articles to show is 10.
    If you change it to 12, you get the error
     
     
  •  
     
    Replied by admin on Monday, April 13 2020, 03:29 PM · Hide· #22
    It because of this article : 10-04-2020: nieuws-item 1
    I tried to unpublish the article and everything goes fine.
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 03:42 PM · Hide· #23
    Ok. I created a new article
    Now it seems to work again.

    For security, I will take a backup of the website :)

    thank you very much for the quick support
    I'm searching now how and where to change the defaul image to an image of the article
     
     
  •  
     
    Replied by seppe155 on Monday, April 13 2020, 05:20 PM · Hide· #24
    ok. thank you very much
    I will make sure I will rename all images

    Lets see what an "_" (underscore) does, instead of an image.
    I will search for the right solution

    thank you
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 02:40 PM · Hide· #25
    Good afternoon

    We are back to the crash, after following your directions in the topic:
    https://www.templateplazza.com/forum/minifrontpage-not-generating-thumbnail
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 02:44 PM · Hide· #26
    It has something to do with multiple categories
    because I use it on another another menu-item, with only 1 categorie, then it works

    But i found the categorie that is making trouble
    So I will search again, and keep you informed
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 03:16 PM · Hide· #27
    there is 1 categorie that always causes the problem.
    I have no idea why.
    I will create a new category and new articles, and see what happens

    keep you informed!
     
     
  •  
     
    Replied by seppe155 on Tuesday, April 14 2020, 04:34 PM · Hide· #28
    update:

    I deleted the categorie
    I deleted all the articles concerning this categorie

    Created everything again from scratch, now it works
     
     
  •  
     
    Replied by admin on Tuesday, April 14 2020, 11:22 PM · Hide· #29
    Ok thank you for the confirmation. Please update me if crash happens again
     
     
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
     
    Replied by mrvargo on Wednesday, April 22 2020, 12:14 PM · Hide· #30
    Hi. I have the exact same error - I have deleted the thumbnail directory and re-installed MFP but it still crashes the page.

    I don't create the articles but there are a large number of old images with spaces in the filenames which also caused problems with the old Latest News+ module.

    I've fixed by renaming several files but would be great to find a solution for this to prevent future errors.

    Thank you
     
     
  •  
     
     
    Replied by admin on Wednesday, April 22 2020, 01:50 PM · Hide· #31
    I've fixed by renaming several files but would be great to find a solution for this to prevent future errors.

    Thank you

    Yes, the update is coming up very soon. Also for latest news+ module

IIS WebApi: 文件上传,大小限制,提示413 (Request Entity Too Large)

我想如果有人按照我的标题搜结果,都是在linux系统上解决方案,或者是java。你是不是很绝望。我懂~

若你是C#研发,其实这个问题的解决方向在IIS上,所以你去搜“IIS 设置文件上传大小限制设置方法”,就会有一堆你想要的答案。我就不贴了。

 

net(C#)项目:当你想要上传时,文件过大,报413时,有两种解决方案,这两种解决方案任选其一就可以

一、在web.config上配置,按照以下格式,将下列标红加粗的地方,按照对应位置复制到web.config中,即可解决。

注:这两个标红处均要复制,配置!!!

 
    httpRuntime 中 maxRequestLength就是设置你上传文件的大小限制;
 
    requestLimits 中 maxAllowedContentLength就是设置你上传文件的大小限制;
 
 
<configuration> <system.web> <compilation targetFramework="4.6.1" /> <httpRuntime executionTimeout="600" maxRequestLength="419430400" targetFramework="4.6.1" /> </system.web> <system.webServer> <security> <requestFiltering> <requestLimits maxAllowedContentLength="419430400" /> </requestFiltering> </security> </system.webServer> </configuration>
 
 

二、IIS中配置

① 打开IIS,找到文件上传的项目,选中->功能试图->配置编辑器(如下图)

1_p67039

 

 ② 修改两处(httpRuntime、requestLimits )

2_p43723

 

 

3_p50694

以上就可以解决文件过大无法上传这个问题。

About Us

Since 1996, our company has been focusing on domain name registration, web hosting, server hosting, website construction, e-commerce and other Internet services, and constantly practicing the concept of "providing enterprise-level solutions and providing personalized service support". As a Dell Authorized Solution Provider, we also provide hardware product solutions associated with the company's services.
 

Contact Us

Address: No. 2, Jingwu Road, Zhengzhou City, Henan Province

Phone: 0086-371-63520088 

QQ:76257322

Website: 800188.com

E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.