vb.org Archive
Page 55 of 164 « First 5455354 55 565765105155 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Mary's Classifieds (https://vborg.vbsupport.ru/showthread.php?t=267194)

BWJ 08-26-2011 10:48 AM
If you have:
Advanced search (all categories in advanced search) = everything is ok
- sub category 1 = gives error while sorting (pushing the arrows)
- sub category 2 = gives error while sorting (pushing the arrows)

BWJ 08-26-2011 10:55 AM
it gives following:

-------------------------------
----- 2011-08-26 13:36:18 -----
-------------------------------
classifieds.php?do=browsegrid
-------------------------------
SQL Error found in query: SELECT count(`id`) FROM `forummicroclassifieds_items` WHERE active = 1 AND hidden = 0 AND sold = 0 AND categoryid IN ()
Error message: 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 ')' at line 1
-------------------------------

-------------------------------
----- 2011-08-26 13:36:18 -----
-------------------------------
classifieds.php?do=browsegrid
-------------------------------
SQL Error found in query: SELECT `id`,`logo`,`adtype`,`title`,`categoryid`,`userid` ,`username`,`newused`,`starts` ,`price`,`location` FROM `forummicroclassifieds_items` WHERE active = 1 AND hidden = 0 AND sold = 0 AND categoryid IN () ORDER BY `title` DESC LIMIT 0,15
Error message: 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 ') ORDER BY `title` DESC LIMIT 0,15' at line 1
-------------------------------

-------------------------------
----- 2011-08-26 13:36:28 -----
-------------------------------
classifieds.php?do=browsegrid
-------------------------------
SQL Error found in query: SELECT count(`id`) FROM `forummicroclassifieds_items` WHERE active = 1 AND hidden = 0 AND sold = 0 AND categoryid IN ()
Error message: 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 ')' at line 1
-------------------------------

-------------------------------
----- 2011-08-26 13:36:28 -----
-------------------------------
classifieds.php?do=browsegrid
-------------------------------
SQL Error found in query: SELECT `id`,`logo`,`adtype`,`title`,`categoryid`,`userid` ,`username`,`newused`,`starts` ,`price`,`location` FROM `forummicroclassifieds_items` WHERE active = 1 AND hidden = 0 AND sold = 0 AND categoryid IN () ORDER BY `title` ASC LIMIT 0,15
Error message: 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 ') ORDER BY `title` ASC LIMIT 0,15' at line 1
-------------------------------

-------------------------------
----- 2011-08-26 13:36:40 -----
-------------------------------
classifieds.php?do=browsegrid
-------------------------------
SQL Error found in query: SELECT count(`id`) FROM `forummicroclassifieds_items` WHERE active = 1 AND hidden = 0 AND sold = 0 AND categoryid IN ()
Error message: 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 ')' at line 1
-------------------------------

maineGuy72 08-26-2011 10:57 AM
awesome job chris cant wait to try it to see how it works

KidCharlemane 08-26-2011 11:14 AM
Does someone have this running somewhere I can see it live?

maineGuy72 08-26-2011 11:25 AM
When i sort the datgrid while browsing it and try to sort i get no results and no errors

maineGuy72 08-26-2011 11:28 AM
Quote:
Originally Posted by KidCharlemane (Post 2238265)
Does someone have this running somewhere I can see it live?
http://www.nhreptile.com/classifieds.php

BWJ 08-26-2011 11:49 AM
Quote:
Originally Posted by maineGuy72 (Post 2238268)
When i sort the datgrid while browsing it and try to sort i get no results and no errors
Yes, I saw that... Strange... I will try to reupload the files

Edit: I tried and the result is the same

maineGuy72 08-26-2011 12:01 PM
ok this might be a carry over bug from ver 4 but if the seller rejects the sale the item is still given a standby code of 1 instead of resetting to 0 and a new buyer is not allowed to click the buy button

nikosb 08-26-2011 12:09 PM
Quote:
Originally Posted by ChrisTERiS (Post 2238229)
  1. Fixed the problem with non-English characters in listings
Thank you Chris!
you are the best !!!

Nikos

fwulfers 08-26-2011 12:39 PM
Quote:
Originally Posted by fwulfers (Post 2236634)
The only thing I noticed is the searchable fields are not showing up in the actual Classified. I have 7 extra searchable fields for this classified but none are showing up: http://saabworld.net/classifieds.php...emid=5&urlid=2

They are showing up fine in the Advanced Search: http://saabworld.net/classifieds.php?do=search
Quote:
Originally Posted by ChrisTERiS (Post 2236637)
This is the problem if you're 55yo:D:D Ok... I forgot to add them in the view ad page. Now you must wait for tomorrow.
The Searchable Fields are not showing up in the view ad page yet. Is it not working on my site or haven't these been added yet in 5.1.1?


All times are GMT. The time now is 01:55 AM.
Page 55 of 164 « First 5455354 55 565765105155 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06119 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete