Jump to content

Recommended Posts

Mysql 5.5

PHP 5.2.3

 

Migrating site and upon cli database import i receive this error:

 

ERROR 1064 (42000) at line 7459: 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

 

the code in question:

 


INSERT INTO `ibf_spider_logs` VALUES (3207171,'adsense-google',NULL,1353121911,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/32838-service-flows-service-classes-and-subscriber-usage-billing/'        ),(3207172,'feedfetcher-google',NULL,1353121946,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/downloads/'),(3207173,'google',NULL,1353122056,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/18171-        sb5120-219014-eng01-shnndmn-added-to-dls-area/'),(3207174,'feedfetcher-google',NULL,1353122061,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=3'),(3207175,'msnbot',NULL        ,1353122095,'157.55.32.80',NULL,NULL,NULL,'/forum/topic/21207-new-validamac-v26-and-manual-added-to-dls-area/'),(3207176,'feedfetcher-google',NULL,1353122140,'209.85.238.187',NULL,NULL,NULL        ,'/forum/index.php/rss/forums/3-tutorials/'),(3207177,'msnbot',NULL,1353122412,'157.55.32.100',NULL,NULL,NULL,'/forum/index.php/topic/30108-5101-motomodz/'),(3207178,'feedfetcher-google',NU        LL,1353123008,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/4-general-all/'),(3207179,'google',NULL,1353123009,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/13125-ipv        iew-40-added-to-dls-area/'),(3207180,'google',NULL,1353123129,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/13125-ipview-40-added-to-dls-area/'),(3207181,'adsense-google',NULL,1353123187,'66.        249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/23774-charter-increases-internet-speeds-for-customers-beginning-march-1-new-configs-posted-here/'),(3207182,'feedfetcher-google',NULL,13531        23356,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=2'),(3207183,'feedfetcher-google',NULL,1353123613,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/2-sb        hacker-firmware/'),(3207184,'msnbot',NULL,1353123792,'65.55.52.87',NULL,NULL,NULL,'/forum/index.php/files/download/479-sb5101-2520-scm01-nosh-nndmnp7/'),(3207185,'msnbot',NULL,1353123857,'1        57.55.33.182',NULL,NULL,NULL,'/forum/index.php/topic/19008-need-help-with-my-sb4200/'),(3207186,'msnbot',NULL,1353124002,'157.55.32.100',NULL,NULL,NULL,'/forum/topic/25381-xbox-live-connect        ion-keeps-disconnecting/'),(3207187,'adsense-google',NULL,1353124007,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/31936-ultimate-charter-config-getting-back-online/'),(3207188,'ads        ense-google',NULL,1353124008,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/31936-ultimate-charter-config-getting-back-online/'),(3207189,'msnbot',NULL,1353124199,'65.55.55.231',NULL        ,NULL,NULL,'/forum/index.php/files/file/590-onestep-zup-15/'),(3207190,'msnbot',NULL,1353124199,'65.55.55.231',NULL,NULL,NULL,'/forum/forum/5-general/'),(3207191,'msnbot',NULL,1353124201,'6        5.55.55.231',NULL,NULL,NULL,'/forum/topic/18938-webstar-dpc2100r2/'),(3207192,'adsense-google',NULL,1353124213,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37464-sb-6141/page__p__191493__hl_        _sb6141__fromsearch__1'),(3207193,'feedfetcher-google',NULL,1353124219,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/downloads/'),(3207194,'msnbot',NULL,1353124309,'65.55.52.111',NU        LL,NULL,NULL,'/forum/index.php/topic/5828-haxorware-0-9-x-discussion/page__st__80__p__27566&'),(3207195,'adsense-google',NULL,1353124446,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/3775        8-sb6121-or-sb6141-dev/page__hl__sb6141__fromsearch__1'),(3207196,'google',NULL,1353124549,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/12006-vpn-service/'),(3207197,'adsense-googl        e',NULL,1353124719,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37464-sb-6141/page__p__190144'),(3207198,'adsense-google',NULL,1353124729,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37464-sb        -6141/page__p__191498'),(3207199,'msnbot',NULL,1353124781,'65.55.52.94',NULL,NULL,NULL,'/forum/topic/19374-sbh-usbjtag-help/'),(3207200,'adsense-google',NULL,1353124790,'66.249.73.17',NULL,        NULL,NULL,'/forum/topic/37503-which-should-i-buy-as-a-second-modem/page__p__190506__hl__sb6141__fromsearch__1'),(3207201,'feedfetcher-google',NULL,1353124795,'209.85.238.187',NULL,NULL,NULL        ,'/forum/rss/forums/4-general-all/'),(3207202,'feedfetcher-google',NULL,1353124866,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/forums/3-tutorials/'),(3207203,'adsense-google',NULL,135312487        8,'66.249.73.17',NULL,NULL,NULL,'/forum/forum/53-general/'),(3207204,'google',NULL,1353125263,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/12006-vpn-service/'),(3207205,'feedfetcher-google',        NULL,1353125590,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/3-tutorials/'),(3207206,'feedfetcher-google',NULL,1353125661,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?a        ct=rssout&id=3'),(3207207,'msnbot',NULL,1353125861,'65.55.55.231',NULL,NULL,NULL,'/forum/index.php/files/download/45-fastsnmp/'),(3207208,'google',NULL,1353126064,'66.249.73.17',NULL,NU        LL,NULL,'/forum/index.php/topic/13727-5101e-unable-to-unbrick/'),(3207209,'feedfetcher-google',NULL,1353126075,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/downloads/'),(3207210,'feedfetcher        -google',NULL,1353126087,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/4-general-all/'),(3207211,'adsense-google',NULL,1353126194,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/        37548-got-a-few-extra-modems-for-sale/'),(3207212,'msnbot',NULL,1353126234,'157.55.33.18',NULL,NULL,NULL,'/forum/topic/26884-flashed-5101-now-cant-access-haxorware-page/'),(3207213,'adsense        -google',NULL,1353126302,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/36400-modems-for-sale-trade/'),(3207214,'msnbot',NULL,1353126406,'65.55.24.239',NULL,NULL,NULL,'/forum/index.php/files/f        ile/78-sb4100-hackware/'),(3207215,'google',NULL,1353126708,'66.249.73.47',NULL,NULL,NULL,'/forum/'),(3207216,'google',NULL,1353126708,'66.249.73.17',NULL,NULL,NULL,'/forum/'),(3207217,'ads        ense-google',NULL,1353126812,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php?app=core&module=global&section=register'),(3207218,'feedfetcher-google',NULL,1353126955,'209.85.238.187'        ,NULL,NULL,NULL,'/forum/index.php?act=rssout&id=2'),(3207219,'feedfetcher-google',NULL,1353127012,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/2-sbhacker-firmware/'),(32        07220,'msnbot',NULL,1353127153,'157.55.35.100',NULL,NULL,NULL,'/forum/index.php/forum/141-ambit-cable-modems/page__prune_day__100__sort_by__Z-A__sort_key__last_post__topicfilter__all__st__6        0'),(3207221,'msnbot',NULL,1353127245,'65.55.24.239',NULL,NULL,NULL,'/forum/index.php/topic/29376-time-warner-cable-launches-extreme-in-cincinatti/'),(3207222,'msnbot',NULL,1353127254,'65.5        5.24.239',NULL,NULL,NULL,'/forum/index.php/topic/3019-sb4200-toshiba-flash-dump/'),(3207223,'msnbot',NULL,1353127460,'65.55.24.239',NULL,NULL,NULL,'/forum/index.php/files/file/408-sbv6220-0        5041-dbg00-ncsnndmnp7/'),(3207224,'adsense-google',NULL,1353127485,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37869-original-full-flash-with-diag-operational/'),(3207225,'msnbot',NULL,1353        127496,'65.55.55.231',NULL,NULL,NULL,'/forum/index.php/files/category/1-sb3100-firmware/'),(3207226,'google',NULL,1353127559,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/members/page__so        rt_key__members_display_name__sort_order__asc__max_results__20__quickjump__O__name_box__begins__name__O__quickjump__E'),(3207227,'msnbot',NULL,1353127610,'157.55.33.18',NULL,NULL,NULL,'/for        um/topic/16606-update-sigma-x2-to-sb5100mod/'),(3207228,'google',NULL,1353127666,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php?app=members&module=list&sort_key=members_display_nam        e&sort_order=asc&max_results=20&quickjump=E&name_box=begins&name=O&k=bb2fe024f8a71424996db6d9af08c1fc&settingNewSkin=7'),(3207229,'msnbot',NULL,1353127974,'65.55        .52.87',NULL,NULL,NULL,'/forum/index.php/topic/2861-uncapping-sb5101-surfboard/'),(3207230,'feedfetcher-google',NULL,1353128265,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/forums/3-tutorial        s/'),(3207231,'feedfetcher-google',NULL,1353128329,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/downloads/'),(3207232,'msnbot',NULL,1353128445,'157.55.35.100',NULL,NULL,NULL,'/foru        m/topic/29897-how-to-become-a-vip-paid-member/'),(3207233,'feedfetcher-google',NULL,1353128644,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/forums/4-general-all/'),(3207234,'adsense-google',        NULL,1353128821,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/16960-will-haxorware-work-on-the-sb5100/'),(3207235,'adsense-google',NULL,1353128913,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/        13932-sb5100-fatsh-1-1-frim-from-diag-modem/'),(3207236,'adsense-google',NULL,1353129000,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/33835-sb5100mod-to-sigma-x2-v15-bpi-hack/'),(3207237,'ad        sense-google',NULL,1353129029,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/34603-cant-get-in-to-1921681001/'),(3207238,'adsense-google',NULL,1353129044,'66.249.73.17',NULL,NULL,NULL,'/forum/        topic/5723-firmware-sb5100mod/'),(3207239,'feedfetcher-google',NULL,1353129070,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/3-tutorials/'),(3207240,'feedfetcher-google',NULL        ,1353129126,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/downloads/'),(3207241,'google',NULL,1353129133,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/15026-sa-2100r2/'),(3207242,'fee        dfetcher-google',NULL,1353129271,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=3'),(3207243,'feedfetcher-google',NULL,1353129288,'209.85.238.187',NULL,NULL,NULL,'/foru        m/index.php/rss/forums/4-general-all/'),(3207244,'msnbot',NULL,1353129296,'157.55.35.100',NULL,NULL,NULL,'/forum/index.php/topic/13613-blackcat-jtag-cable-for-dpc2100r2/'),(3207245,'google'        ,NULL,1353129734,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/15026-sa-2100r2/'),(3207246,'msnbot',NULL,1353130031,'65.55.52.111',NULL,NULL,NULL,'/forum/index.php/topic/13217-force-docsis-2-

 

Im not very versed in mysql so i have no idea, the db was fine before so im at a loss as to why its throwing the error. thank you in advance for any light anyone can shed.

 

Josh

Link to comment
https://forums.phpfreaks.com/topic/272627-database-import-error/
Share on other sites

I have reformated your code and removed all the spurious white space that I HOPE came from the copy/paste process. as it stands your code is incomplete :

INSERT INTO `ibf_spider_logs`
VALUES
(3207171,'adsense-google',NULL,1353121911,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/32838-service-flows-service-classes-and-subscriber-usage-billing/'),
(3207172,'feedfetcher-google',NULL,1353121946,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/downloads/'),
(3207173,'google',NULL,1353122056,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/18171-sb5120-219014-eng01-shnndmn-added-to-dls-area/'),
(3207174,'feedfetcher-google',NULL,1353122061,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=3'),
(3207175,'msnbot',NULL,1353122095,'157.55.32.80',NULL,NULL,NULL,'/forum/topic/21207-new-validamac-v26-and-manual-added-to-dls-area/'),
(3207176,'feedfetcher-google',NULL,1353122140,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/3-tutorials/'),
(3207177,'msnbot',NULL,1353122412,'157.55.32.100',NULL,NULL,NULL,'/forum/index.php/topic/30108-5101-motomodz/'),
(3207178,'feedfetcher-google',NULL,1353123008,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/4-general-all/'),
(3207179,'google',NULL,1353123009,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/13125-ipview-40-added-to-dls-area/'),
(3207180,'google',NULL,1353123129,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/13125-ipview-40-added-to-dls-area/'),
(3207181,'adsense-google',NULL,1353123187,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/23774-charter-increases-internet-speeds-for-customers-beginning-march-1-new-configs-posted-here/'),
(3207182,'feedfetcher-google',NULL,1353123356,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=2'),
(3207183,'feedfetcher-google',NULL,1353123613,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/2-sbhacker-firmware/'),
(3207184,'msnbot',NULL,1353123792,'65.55.52.87',NULL,NULL,NULL,'/forum/index.php/files/download/479-sb5101-2520-scm01-nosh-nndmnp7/'),
(3207185,'msnbot',NULL,1353123857,'157.55.33.182',NULL,NULL,NULL,'/forum/index.php/topic/19008-need-help-with-my-sb4200/'),
(3207186,'msnbot',NULL,1353124002,'157.55.32.100',NULL,NULL,NULL,'/forum/topic/25381-xbox-live-connection-keeps-disconnecting/'),
(3207187,'adsense-google',NULL,1353124007,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/31936-ultimate-charter-config-getting-back-online/'),
(3207188,'adsense-google',NULL,1353124008,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/31936-ultimate-charter-config-getting-back-online/'),
(3207189,'msnbot',NULL,1353124199,'65.55.55.231',NULL,NULL,NULL,'/forum/index.php/files/file/590-onestep-zup-15/'),
(3207190,'msnbot',NULL,1353124199,'65.55.55.231',NULL,NULL,NULL,'/forum/forum/5-general/'),
(3207191,'msnbot',NULL,1353124201,'65.55.55.231',NULL,NULL,NULL,'/forum/topic/18938-webstar-dpc2100r2/'),
(3207192,'adsense-google',NULL,1353124213,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37464-sb-6141/page__p__191493__hl__sb6141__fromsearch__1'),
(3207193,'feedfetcher-google',NULL,1353124219,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/downloads/'),
(3207194,'msnbot',NULL,1353124309,'65.55.52.111',NULL,NULL,NULL,'/forum/index.php/topic/5828-haxorware-0-9-x-discussion/page__st__80__p__27566&'),
(3207195,'adsense-google',NULL,1353124446,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37758-sb6121-or-sb6141-dev/page__hl__sb6141__fromsearch__1'),
(3207196,'google',NULL,1353124549,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/12006-vpn-service/'),
(3207197,'adsense-google',NULL,1353124719,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37464-sb-6141/page__p__190144'),
(3207198,'adsense-google',NULL,1353124729,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37464-sb-6141/page__p__191498'),
(3207199,'msnbot',NULL,1353124781,'65.55.52.94',NULL,NULL,NULL,'/forum/topic/19374-sbh-usbjtag-help/'),
(3207200,'adsense-google',NULL,1353124790,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37503-which-should-i-buy-as-a-second-modem/page__p__190506__hl__sb6141__fromsearch__1'),
(3207201,'feedfetcher-google',NULL,1353124795,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/forums/4-general-all/'),
(3207202,'feedfetcher-google',NULL,1353124866,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/forums/3-tutorials/'),
(3207203,'adsense-google',NULL,1353124878,'66.249.73.17',NULL,NULL,NULL,'/forum/forum/53-general/'),
(3207204,'google',NULL,1353125263,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/12006-vpn-service/'),
(3207205,'feedfetcher-google',NULL,1353125590,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/3-tutorials/'),
(3207206,'feedfetcher-google',NULL,1353125661,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=3'),
(3207207,'msnbot',NULL,1353125861,'65.55.55.231',NULL,NULL,NULL,'/forum/index.php/files/download/45-fastsnmp/'),
(3207208,'google',NULL,1353126064,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/13727-5101e-unable-to-unbrick/'),
(3207209,'feedfetcher-google',NULL,1353126075,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/downloads/'),
(3207210,'feedfetcher-google',NULL,1353126087,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/4-general-all/'),
(3207211,'adsense-google',NULL,1353126194,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37548-got-a-few-extra-modems-for-sale/'),
(3207212,'msnbot',NULL,1353126234,'157.55.33.18',NULL,NULL,NULL,'/forum/topic/26884-flashed-5101-now-cant-access-haxorware-page/'),
(3207213,'adsense-google',NULL,1353126302,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/36400-modems-for-sale-trade/'),
(3207214,'msnbot',NULL,1353126406,'65.55.24.239',NULL,NULL,NULL,'/forum/index.php/files/file/78-sb4100-hackware/'),
(3207215,'google',NULL,1353126708,'66.249.73.47',NULL,NULL,NULL,'/forum/'),
(3207216,'google',NULL,1353126708,'66.249.73.17',NULL,NULL,NULL,'/forum/'),
(3207217,'adsense-google',NULL,1353126812,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php?app=core&module=global&section=register'),
(3207218,'feedfetcher-google',NULL,1353126955,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=2'),
(3207219,'feedfetcher-google',NULL,1353127012,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/2-sbhacker-firmware/'),
(3207220,'msnbot',NULL,1353127153,'157.55.35.100',NULL,NULL,NULL,'/forum/index.php/forum/141-ambit-cable-modems/page__prune_day__100__sort_by__Z-A__sort_key__last_post__topicfilter__all__st__60'),
(3207221,'msnbot',NULL,1353127245,'65.55.24.239',NULL,NULL,NULL,'/forum/index.php/topic/29376-time-warner-cable-launches-extreme-in-cincinatti/'),
(3207222,'msnbot',NULL,1353127254,'65.55.24.239',NULL,NULL,NULL,'/forum/index.php/topic/3019-sb4200-toshiba-flash-dump/'),
(3207223,'msnbot',NULL,1353127460,'65.55.24.239',NULL,NULL,NULL,'/forum/index.php/files/file/408-sbv6220-05041-dbg00-ncsnndmnp7/'),
(3207224,'adsense-google',NULL,1353127485,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/37869-original-full-flash-with-diag-operational/'),
(3207225,'msnbot',NULL,1353127496,'65.55.55.231',NULL,NULL,NULL,'/forum/index.php/files/category/1-sb3100-firmware/'),
(3207226,'google',NULL,1353127559,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/members/page__sort_key__members_display_name__sort_order__asc__max_results__20__quickjump__O__name_box__begins__name__O__quickjump__E'),
(3207227,'msnbot',NULL,1353127610,'157.55.33.18',NULL,NULL,NULL,'/forum/topic/16606-update-sigma-x2-to-sb5100mod/'),
(3207228,'google',NULL,1353127666,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php?app=members&module=list&sort_key=members_display_name&sort_order=asc&max_results=20&quickjump=E&name_box=begins&name=O&k=bb2fe024f8a71424996db6d9af08c1fc&settingNewSkin=7'),
(3207229,'msnbot',NULL,1353127974,'65.55.52.87',NULL,NULL,NULL,'/forum/index.php/topic/2861-uncapping-sb5101-surfboard/'),
(3207230,'feedfetcher-google',NULL,1353128265,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/forums/3-tutorials/'),
(3207231,'feedfetcher-google',NULL,1353128329,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/downloads/'),
(3207232,'msnbot',NULL,1353128445,'157.55.35.100',NULL,NULL,NULL,'/forum/topic/29897-how-to-become-a-vip-paid-member/'),
(3207233,'feedfetcher-google',NULL,1353128644,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/forums/4-general-all/'),
(3207234,'adsense-google',NULL,1353128821,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/16960-will-haxorware-work-on-the-sb5100/'),
(3207235,'adsense-google',NULL,1353128913,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/13932-sb5100-fatsh-1-1-frim-from-diag-modem/'),
(3207236,'adsense-google',NULL,1353129000,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/33835-sb5100mod-to-sigma-x2-v15-bpi-hack/'),
(3207237,'adsense-google',NULL,1353129029,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/34603-cant-get-in-to-1921681001/'),
(3207238,'adsense-google',NULL,1353129044,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/5723-firmware-sb5100mod/'),
(3207239,'feedfetcher-google',NULL,1353129070,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/3-tutorials/'),
(3207240,'feedfetcher-google',NULL,1353129126,'209.85.238.187',NULL,NULL,NULL,'/forum/rss/downloads/'),
(3207241,'google',NULL,1353129133,'66.249.73.17',NULL,NULL,NULL,'/forum/index.php/topic/15026-sa-2100r2/'),
(3207242,'feedfetcher-google',NULL,1353129271,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php?act=rssout&id=3'),
(3207243,'feedfetcher-google',NULL,1353129288,'209.85.238.187',NULL,NULL,NULL,'/forum/index.php/rss/forums/4-general-all/'),
(3207244,'msnbot',NULL,1353129296,'157.55.35.100',NULL,NULL,NULL,'/forum/index.php/topic/13613-blackcat-jtag-cable-for-dpc2100r2/'),
(3207245,'google',NULL,1353129734,'66.249.73.17',NULL,NULL,NULL,'/forum/topic/15026-sa-2100r2/'),
(3207246,'msnbot',NULL,1353130031,'65.55.52.111',NULL,NULL,NULL,'/forum/index.php/topic/13217-force-docsis-2-

as you can see the last line is unfinnished. If you layout your actual query in this way you will get a much more helpfull line number refference in the error and it will save everyone quite some time in the long run.

Edited by Muddy_Funster
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.