Thread: Major Additions - microAUCTIONS (Auction Classifieds)
View Single Post
  #106  
Old 06-14-2010, 12:50 PM
WhiskeyOSS WhiskeyOSS is offline
 
Join Date: Mar 2010
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MicroHellas View Post
Just one spelling error?? ..lol.. Then it seems that I've improved my English. Don't forget that English is not my mothertongue. You can edit all phrases from phrase manager at your admincp.

Maria
Quote:
Originally Posted by WhiskeyOSS View Post
When I tried to use an ' (apostrophe) in a sub catagory listing I kept getting this error message got any Idea's as to why ?

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO microauctions_categories
SET name='CPU's New and Used',
displayorder='0',
parentid='1';

MySQL Error : 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 's New and Used',
displayorder='0',
' at line 2
Error Number : 1064
Request Date : Monday, June 7th 2010 @ 11:03:39 PM
Quote:
Originally Posted by WhiskeyOSS View Post
Every time a item is posted and someone attempts to view this item we get this error message I have uninstalled this hack till this is resolved as I was unable to remove the items from the listings.


Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT * FROM microauctions_item_hits WHERE itemid=4;

MySQL Error : Incorrect information in file: './mtoler_OSSAuctions/microauctions_item_hits.frm'
Error Number : 1033
Request Date : Tuesday, June 8th 2010 @ 04:21:13 PM
Error Date : Tuesday, June 8th 2010 @ 04:21:28 PM
Script : http://www.oldschoolshooters.net/OSS...witem&itemid=4
Referrer : http://www.oldschoolshooters.net/OSS...o=main&catid=8
IP Address : 24.100.76.46
Username :
Classname : vB_Database
MySQL Version : 5.1.46
Quote:
Originally Posted by WhiskeyOSS View Post
I Had to uninstall do to error issues Now its a nightmare of error issues its not on my site any longer (uninstalled) but yet I keep getting these errors over and over NEED SOME HELP HERE The catagory listed in the error below DOES NOT EXIST from what I can see..

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_microauctions AS phrasegroup_microauctions,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_posting AS phrasegroup_posting,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_microauctions' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Error Date : Tuesday, June 8th 2010 @ 07:50:29 PM
Script : http://www.oldschoolshooters.net/OSS...=main&catid=20
Referrer :
IP Address : 66.249.71.236
Username :
Classname : vB_Database

For a temp fix to stop the sql errors I removed auctions.php from the data base now it just gives a page not found error.
Quote:
Originally Posted by WhiskeyOSS View Post
Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?
WhiskeyOSS;2053432]Have you looked into the error messages I posted ? Do you have any idea how to get it to work correctly as this is the Item I need for my site ?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01699 seconds
  • Memory Usage 1,792KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete