Mutare baza de date

Threaded Mode | Linear Mode

Mutare baza de date

Author Message

libotean
De al casei

Posts: 71
Group: Registered
Joined: Sep 2007
Status: Away
Reputation: 0
Lei: 348.37

Post: #1

Mutare baza de date

Am de pe un forum o baza de date , dar cand sa o pun pe alt site prin phpmyadmin (care are 25mb) imi da o eroare.Chiar daca fac asa .Import -> Aleg fisierul ->Go

Apoi imi da eroarea asta :

Code:

Error

There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:

----BEGIN CUT----

eNotjs9ugkAYxO/7FHMwQRPY7K4Isj0Rs7EmCJRFm/Ri/EMrCYIFTNXXqA9cMD3NLzNfvhmVJFEi

MeOYCQQqlHA9TBk8h+i0Cx6E6HXnDhYHiea7OG/rJqtpke/o+XgGZ/ZYQDDmWsyxOAd3JWNy4nyg

yE4eBmR502+BxIQyak+sfXU6Xcq8vVlF9UVWOkGkTfhzFaYm1qorfM9LRLFKfHhU2CRe+hKCck4Z

iV/j/saMdP9P0DGCvLxcSeCHc4mstC7tpzUlzz6yCLVKUizCNEK3dLfbNNm23h83P1V9KPKmxbCn

TZtdWxNPzA//0K+syhHWfrBSemj83h+GCUNMbadXZoxe/gDWM1cZ

----END CUT----

----BEGIN RAW----

ERROR: C1 C2 LEN: 79 80 96

STR: ï¿½

SVN: $Id: sqlparser.lib.php 10432 2007-06-11 17:00:56Z lem9 $

MySQL: 5.0.45-community-log

USR OS, AGENT, VER: Win OPERA 9.24

PMA: 2.11.0

PHP VER,OS: 5.2.3 Linux

LANG: en-utf-8

SQL: 

INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('ï¿½zï¿½', '2846', '0');

----END RAW----

SQL query: 

INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('ï¿½zï¿½', '2846', '0'); 

MySQL said:  

#1062 - Duplicate entry '?z?' for key 1

Deja nu mai stiu sa fac.Daca ma poate ajuta cineva va rog sa imi dati un ID de messenger sau intrati voi pe al meu libotean_dan , ca deja nu mai stiu ce sa ma fac.

Apoi dupa ce am dat browse imi apare eroarea asta

Code:

Error

SQL query:  

SELECT * 

FROM Array

WHERE CONCAT_WS( "-", word_text, word_id, word_common ) = "?z?"

ORDER BY word_text, word_id, word_common

LIMIT 0 , 30 

MySQL said:  

#1146 - Table 'porumbel_forum.Array' doesn't exist

11-03-2007 02:59 AM

Mihai_Only
Designer incepator

Posts: 306
Group: Registered
Joined: Jul 2007
Status: Offline
Reputation: 0
Lei: 925.92

Post: #2

RE: Mutare baza de date

Am mai Ã®ntÃ¢lnit eroarea asta cÃ¢nd am mutat free-time'ul de pe myforum.ro pe velhost.Åžterge din fiÅŸierul sql toate tabelele search_wordlist sau mai bine zis: toate liniile ce Ã®ncep cu segvenÅ£a:

Code:

phpbb_search_wordlist

|bancuri|Statusuri|Mihai's Blog

This post was last modified: 11-03-2007 04:10 AM by Mihai_Only.

11-03-2007 03:57 AM

libotean
De al casei

Posts: 71
Group: Registered
Joined: Sep 2007
Status: Away
Reputation: 0
Lei: 348.37

Post: #3

RE: Mutare baza de date

Salut.Intra te rog pe ID libotean_dan , pun o luna bannerul site-ului tau in siteul meu numai sa ma ajuti cu aceasta problema.

Multumesc.

11-03-2007 04:22 AM

Grim_Cris
Designer experimentat

Posts: 668
Group: Registered
Joined: Jun 2007
Status: Offline
Reputation: 0
Lei: 1289.77

Post: #4

RE: Mutare baza de date

am intalnit si eu problema cÃ¢nd am mutat hostul la http://www.decodari.info ...fÄƒ ce Å£i-a zis mihai ... acum depinde ÅŸi ce fel ai salvat baza de date(asta selectezi cÃ¢nd faci export din phpmyadmin)

Grim_Cris va prezinta:
Decodari Telefoane prin IMEI | PRDirector | Shiny Hair

11-04-2007 05:53 AM

gold21c
Designer incepator

Posts: 285
Group: Registered
Joined: Oct 2007
Status: Offline
Reputation: 0
Lei: 866.08

Post: #5

RE: Mutare baza de date

problema este de la tabelul phpbb_search_wordlist. trebuie sa incerci inserarea fara acest tabel si problema ta se va rezolva.

Play Free Online Games | Free Online Games to Play

11-04-2007 07:58 AM

dexter
Designer incepator

Posts: 219
Group: Registered
Joined: Jan 2007
Status: Offline
Reputation: 0
Lei: 488.76

Post: #6

RE: Mutare baza de date

Daca ai acces ssh ai putea sa importi direct fisierul in tabela.. si s-ar putea sa nu mai ai aceasta eroare.
Ai rezolvat cu problema? Contacteaza-ma pe efelicitari.suport si poate te ajut eu

felicitari | blogul meu personal | filme, subtitrari | lyrics | programare web

11-20-2007 04:30 AM

« Next Oldest | Next Newest »

Possibly Related Threads...
Thread:		Author	Replies:	Views:	Last Post
	Introducere & afisare din baza de date	DJ Roly	5	101	05-01-2008 04:03 PM Last Post: Agkelos
	conectare la baza de date de pe alt server	DJ Roly	5	212	02-21-2008 06:22 AM Last Post: DJ Roly

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump: