vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   have problem with my database ? (https://vborg.vbsupport.ru/showthread.php?t=222457)

chennairam 09-04-2009 11:55 AM

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

https://vborg.vbsupport.ru/external/2009/09/70.jpg


In red Box i Marked

snakes1100 09-04-2009 12:37 PM

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.

chennairam 09-04-2009 01:33 PM

really Dont understand

Can tell me Extractly please

snakes1100 09-04-2009 02:15 PM

Log into your cpanel and check the user that you assigned to your database and make sure he has delete permissions for said database.

chennairam 09-04-2009 04:08 PM

Quote:

Originally Posted by snakes1100 (Post 1879648)
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

snakes1100 09-04-2009 04:27 PM

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.

chennairam 09-05-2009 01:00 AM

Quote:

Originally Posted by snakes1100 (Post 1879713)
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

snakes1100 09-05-2009 10:30 AM

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?

chennairam 09-06-2009 01:51 AM

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

https://vborg.vbsupport.ru/external/2009/09/64.jpg

https://vborg.vbsupport.ru/external/2009/09/65.jpg

Please Help me Lot of thread missing

chennairam 09-07-2009 02:25 AM

Please help me anyone please still problem exist


All times are GMT. The time now is 09:07 PM.

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.01995 seconds
  • Memory Usage 1,735KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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