WebProWorld Part of WebProNews.com
Page One Link To Us Edit Profile Private Messages Archives FAQ RSS Feeds  
 

Go Back   WebProWorld > Webmaster, IT and Security Discussion > Web Programming Discussion Forum
Subscribe to the Newsletter FREE!


Register FAQ Members List Calendar Arcade Chatbox Mark Forums Read

Web Programming Discussion Forum Working with an API? Developing a plugin? Writing a Mod or script for your favorite blog, Web 2.0 site or Forum? Welcome.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-23-2006, 11:33 AM
bobkom's Avatar
WebProWorld Pro
 

Join Date: May 2004
Location: indianworld
Posts: 155
bobkom RepRank 0
Default PhpBB forum getting error while restoring DB

dear friends,

please help us to retify an error while restoring DB in Phpbb forum

am restored Phpbb DB in Non Gzipped format file to restore database. we encountered with error.

as before taking backup our site configured with Sub verror template. so when we wished to restore. we newly instaled same version of phpbb forum. its 2.0.16 version. first we changed sub sliver to sub verror. when all working fine we went admin control of phpbb adminstration . there we restored our DB file , then we got error..

for yur refrence am pasting the error.

General Error
Error importing backup file

DEBUG MODE

SQL Error : 1064 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 '148', '71a1aa6758', 'U.S.-India Joint Statement', 'For Immediat

INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('147', '2fde131823', 'U.S.-India Joint Statement on Trade', 'For Immediate Release Office of the Press Secretary March 2, 2006 U.S.-India Joint Statement on Trade Fact sheetPresident\'s Visit to India and Pakistan Fact sheetIn Focus: International Trade India and the United States agree that trade is essential to promoting global economic growth, development, freedom and prosperity. We fully share the goal of completing the WTO Doha Development Agenda (DDA) before the end of 2006, and agree to work in partnership to help achieve this outcome. During our discussions, we agreed to meet the task with ambition, determination and a readiness to contribute, consistent with our roles in global trade, and to keep the development dimension in focus. The system of trading rules to which our two great democracies have contributed immensely must be strengthened. Towards this global cause, we recommit ourselves and invite all key participants to demonstrate their leadership. We agree that a successful Round depends upon progress in all areas of the negotiations if we are to meet our goal of promoting development through trade. We are committed to a DDA result consistent with the mandates already agreed that realize a substantial outcome in all three pillars of the agriculture negotiations (domestic support, export competition and market access); significant improvements in market opportunities in manufacturing and services; and appropriate disciplines, including transparency of regulatory practices in services. We also believe we should strengthen the rules that facilitate trade, where we have jointly made proposals. Work in all these areas must go hand in hand. We agree to pursue an ambitious agenda for the first half of 2006,consistent with the important milestones that were set at the Hong Kong Ministerial for agriculture, manufacturing, services and other issues, and continuing to press for the goal of concluding the negotiations by the end of 2006. We will continue to work to promote reform, respond to the concerns of developing countries, and create opportunities for growth for all. We are building the trading system of the future, where progressive liberalization and reform result in improvement in standards of living for all, in particular for the millions of poor across the developing world. While working for a successful Doha Round, we also reaffirm our commitment to strengthen and deepen bilateral trading ties. We note with satisfaction the successful implementation of our initiative to create the U.S.-India Trade Policy Forum and the CEO Forum to this end, and in particular the achievements in the areas of agricultural trade, investment, trade in services, the reduction of tariff and non-tariff barriers to trade, and spurring innovation and creativity. We agree to promote innovation, creativity and technological advancement by providing a vibrant intellectual property rights regime. As two dynamic economies with many complementary interests, the U.S. and India will seek to enhance bilateral trade and investment ties by expanding private sector contacts, dismantling barriers to trade, building trade capacities and strengthening trade-promoting institutions. INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('148', '71a1aa6758', 'U.S.-India Joint Statement', 'For Immediate Release Office of the Press Secretary March 2, 2006 U.S.-India Joint Statement Fact sheetPresident\'s Visit to India and Pakistan President George W. Bush and Prime Minister Manmohan Singh today expressed satisfaction with the great progress the United States and India have made in advancing our strategic partnership to meet the global challenges of the 21st century. Both our countries are linked by a deep commitment to freedom and democracy

Line : 980
File : admin_db_utilities.php


plz suggest a soloution to us..

thanks in advance.
__________________
Mission www.INdianworld.IN
Reply With Quote
  #2 (permalink)  
Old 03-23-2006, 12:10 PM
WebProWorld 1,000+ Club
 

Join Date: Jul 2003
Location: Toronto, Canada
Posts: 2,193
cyanide RepRank 0
Default

Do you have access to phpMyAdmin.?
This program is better for manipulating mysql
__________________
|
Web Hosting Guru
| Need Help For Your Forum?
Reply With Quote
  #3 (permalink)  
Old 03-23-2006, 03:47 PM
bobkom's Avatar
WebProWorld Pro
 

Join Date: May 2004
Location: indianworld
Posts: 155
bobkom RepRank 0
Default PhpBB forum getting error while restoring DB

Quote:
Originally Posted by cyanide
Do you have access to phpMyAdmin.?
This program is better for manipulating mysql
yes friend i had it.. but how it can help me as i have sql DB with me? can you plz make your time for restoring my DB..
thanks in advcance.
__________________
Mission www.INdianworld.IN
Reply With Quote
  #4 (permalink)  
Old 03-23-2006, 05:17 PM
bobkom's Avatar
WebProWorld Pro
 

Join Date: May 2004
Location: indianworld
Posts: 155
bobkom RepRank 0
Default

if you guide me here.. illfollow and restore my DB in my phpbb forum..
__________________
Mission www.INdianworld.IN
Reply With Quote
Reply

  WebProWorld > Webmaster, IT and Security Discussion > Web Programming Discussion Forum
Tags: , , , , ,



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Search Engine Optimization by vBSEO 3.2.0