Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2009, 12:55 PM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default have problem with my database ?

Hi People please Tel me

In my database i can see some Row Newly

Can any body tell what is that Rows




In red Box i Marked
Reply With Quote
  #2  
Old 09-04-2009, 01:37 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sounds like your db user dont have the correct permissions on the db and can't delete tables correctly.

Unless your generating 1000's of them, i wouldnt worry about it.

Check your user for the db has full delete permissions on the db.
Reply With Quote
  #3  
Old 09-04-2009, 02:33 PM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

really Dont understand

Can tell me Extractly please
Reply With Quote
  #4  
Old 09-04-2009, 03:15 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Log into your cpanel and check the user that you assigned to your database and make sure he has delete permissions for said database.
Reply With Quote
  #5  
Old 09-04-2009, 05:08 PM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by snakes1100 View Post
Log into your cpanel and check the user that you assigned to your database and make sure he has delete permissions for said database.
only one user i assigned

how can i delete that now
Reply With Quote
  #6  
Old 09-04-2009, 05:27 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just edit the user thru the db admin interface in cpanel and make sure it has delete permissions assigned to it, there is no need to delete the current user.
Reply With Quote
  #7  
Old 09-05-2009, 02:00 AM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by snakes1100 View Post
Just edit the user thru the db admin interface in cpanel and make sure it has delete permissions assigned to it, there is no need to delete the current user.
Really i dont understand.... i made backup of my database database.sql.gz

after i extract it will 158mb

after i imported but i dont current style and current users i lost more than 8000+ users

in phpmyadmin i can see more all users like 53.737 users


In forum i cant see

--------------- Added [DATE]1252124117[/DATE] at [TIME]1252124117[/TIME] ---------------

Really Strange Problem

When i trying to import my shared hosting getting this error

Server Replied: ERROR 1062 (23000)
at line 534375:
Duplicate entry
'???????' for key 2
ERROR 1062 (23000)
at line 535899:
Duplicate entry '??'
for key 2
ERROR 1062 (23000)
at line 537412:
Duplicate entry
'???????' for key 2
ERROR 1062 (23000)
at line 538960:
Duplicate entry
'????' for key 2
ERROR 1062 (23000)
at line 540498:
Duplicate entry
'???????????' for
key 2
ERROR 1062 (23000)
at line 542029:
Duplicate entry '??'
for key 2
ERROR 1062 (23000)
at line 543536:
Duplicate entry
'?????' for key 2
ERROR 1062 (23000)
at line 544992:
Duplicate entry
'?????' for key 2
ERROR 1062 (23000)
at line 546486:
Duplicate entry
'????' for key 2
Reply With Quote
  #8  
Old 09-05-2009, 11:30 AM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The user im speaking of is the username set in your config.php file that you created/setup in cpanel, your server responds on port 2082, so i know you have cpanel.

The error you posted about now, you can run a repair on your db tables with phpmyadmin and try to repair it, if not you will need to speak to your host.

Why did you import a back up anyways?
Reply With Quote
  #9  
Old 09-06-2009, 02:51 AM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sir can you tell me How to Repair ... i didnt set Anything in config.php

Really My old server have some problems
so backup and import

If Import Without any error Some times

But All user And setting Okey

Lot of Thread & posts Missing

here The Screenshots





Please Help me Lot of thread missing
Reply With Quote
  #10  
Old 09-07-2009, 03:25 AM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please help me anyone please still problem exist
Reply With Quote
Reply


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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:08 AM.


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.04295 seconds
  • Memory Usage 2,250KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete