Podstrony
- telcocafe
- [php] Dodanie textu do pliku. Problem... :) POMOCY!!!!!!!!!!!!!
- Problem ze zgrywaniem z kamery Problem ze zgrywaniem z kamery
- [JS] Problem ze skryptem pobierającym źródło strony skrypt pobierający źródło strony
- Głupi problem HELP !!!
- [JS, jQuery] Problem z przejściem z JS na jQuery
- [HTML] 2 problemy z html-em
- [domena] Problem z domeną
- Problem z O/C - Barton 2800+ AMD Athlon XP 2800+ Barton
- Problem z SP2 NIE uruchamia mi sie system !!!
- Problem z Koszem systemowym POMOCY!!!
- zanotowane.pl
- doc.pisz.pl
- pdf.pisz.pl
- ricofoto.xlx.pl
telcocafe
Gdy wgrywam sql do bazy danych wyskakuje mi taki blad:Error
SQL-query : [Edit]
LOCK TABLES additional_info WRITE
MySQL said:
Access denied for user: 'total89_uk' to database 'total89_uk_db'
Przesylam zawartosc pliku sql:
CREATE TABLE additional_info ( mem_id int(11) default NULL, age int(3) default NULL, gender enum('Male','Female') default NULL, marital varchar(10) default NULL, household char(2) default NULL, childrens char(2) default NULL, income varchar(7) default NULL, housestatus varchar(6) default NULL, learning varchar(15) default NULL, occupation varchar(6) default NULL, vehicles varchar(6) default NULL, creditcard enum('yes','no') default NULL, spentonline varchar(4) default NULL, interests text, html_email enum('yes','no') default NULL ) TYPE=MyISAM; /*!40000 ALTER TABLE additional_info DISABLE KEYS */; # # Dumping data for table 'additional_info' # LOCK TABLES additional_info WRITE; /*!40000 ALTER TABLE additional_info ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'advt_banner' # DROP TABLE IF EXISTS advt_banner; CREATE TABLE advt_banner ( ad_id varchar(16) NOT NULL default '0', email_id varchar(50) NOT NULL default '', name varchar(20) NOT NULL default '', title varchar(20) NOT NULL default '', imp_purchased int(11) default NULL, imp_used int(11) NOT NULL default '0', PRIMARY KEY (ad_id) ) TYPE=MyISAM; /*!40000 ALTER TABLE advt_banner DISABLE KEYS */; # # Dumping data for table 'advt_banner' # LOCK TABLES advt_banner WRITE; /*!40000 ALTER TABLE advt_banner ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'advt_email' # DROP TABLE IF EXISTS advt_email; CREATE TABLE advt_email ( ad_id varchar(16) NOT NULL default '0', email_id varchar(50) NOT NULL default '', name varchar(20) NOT NULL default '', title varchar(20) NOT NULL default '', url varchar(150) default NULL, amt_perclick float(5,2) NOT NULL default '0.00', clicks_recd int(6) NOT NULL default '0', type varchar(7) default NULL, info text, PRIMARY KEY (ad_id) ) TYPE=MyISAM; /*!40000 ALTER TABLE advt_email DISABLE KEYS */; # # Dumping data for table 'advt_email' # LOCK TABLES advt_email WRITE; /*!40000 ALTER TABLE advt_email ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'banner' # DROP TABLE IF EXISTS banner; CREATE TABLE banner ( banner_id int(5) unsigned NOT NULL auto_increment, title varchar(30) default NULL, html text, user varchar(50) default NULL, clicks int(11) default NULL, PRIMARY KEY (banner_id) ) TYPE=MyISAM; /*!40000 ALTER TABLE banner DISABLE KEYS */; # # Dumping data for table 'banner' # LOCK TABLES banner WRITE; /*!40000 ALTER TABLE banner ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'banner_clicks' # DROP TABLE IF EXISTS banner_clicks; CREATE TABLE banner_clicks ( member_id varchar(50) binary NOT NULL default '''''', banner_id int(4) unsigned NOT NULL default '0', click_date date NOT NULL default '0000-00-00', PRIMARY KEY (member_id,banner_id,click_date) ) TYPE=MyISAM; /*!40000 ALTER TABLE banner_clicks DISABLE KEYS */; # # Dumping data for table 'banner_clicks' # LOCK TABLES banner_clicks WRITE; /*!40000 ALTER TABLE banner_clicks ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'banner_imp' # DROP TABLE IF EXISTS banner_imp; CREATE TABLE banner_imp ( banner_id int(4) unsigned NOT NULL auto_increment, count int(5) unsigned default '0', click_date date NOT NULL default '0000-00-00', PRIMARY KEY (banner_id,click_date) ) TYPE=MyISAM; /*!40000 ALTER TABLE banner_imp DISABLE KEYS */; # # Dumping data for table 'banner_imp' # LOCK TABLES banner_imp WRITE; /*!40000 ALTER TABLE banner_imp ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'contact_us' # DROP TABLE IF EXISTS contact_us; CREATE TABLE contact_us ( email_id varchar(50) NOT NULL default '', name varchar(25) NOT NULL default '', q_type varchar(100) NOT NULL default '', q_desc varchar(100) default NULL, question text ) TYPE=MyISAM; /*!40000 ALTER TABLE contact_us DISABLE KEYS */; # # Dumping data for table 'contact_us' # LOCK TABLES contact_us WRITE; /*!40000 ALTER TABLE contact_us ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'email_clicks' # DROP TABLE IF EXISTS email_clicks; CREATE TABLE email_clicks ( ad_id varchar(30) NOT NULL default '0', clicks int(11) NOT NULL default '0', date date default NULL ) TYPE=MyISAM; /*!40000 ALTER TABLE email_clicks DISABLE KEYS */; # # Dumping data for table 'email_clicks' # LOCK TABLES email_clicks WRITE; /*!40000 ALTER TABLE email_clicks ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'member_credit' # DROP TABLE IF EXISTS member_credit; CREATE TABLE member_credit ( mem_id int(11) default NULL, r_credit text, credits float(5,2) default NULL, c_date date default NULL ) TYPE=MyISAM; /*!40000 ALTER TABLE member_credit DISABLE KEYS */; # # Dumping data for table 'member_credit' # LOCK TABLES member_credit WRITE; /*!40000 ALTER TABLE member_credit ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'member_debit' # DROP TABLE IF EXISTS member_debit; CREATE TABLE member_debit ( mem_id int(11) default NULL, r_debit text, debits float(5,2) default NULL, d_date date default NULL ) TYPE=MyISAM; /*!40000 ALTER TABLE member_debit DISABLE KEYS */; # # Dumping data for table 'member_debit' # LOCK TABLES member_debit WRITE; /*!40000 ALTER TABLE member_debit ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'member_details' # DROP TABLE IF EXISTS member_details; CREATE TABLE member_details ( mem_id int(11) NOT NULL auto_increment, email_id varchar(50) NOT NULL default '', f_name varchar(25) NOT NULL default '', l_name varchar(25) NOT NULL default '', address varchar(150) default NULL, city varchar(25) default NULL, state varchar(25) default NULL, zip varchar(15) default NULL, country varchar(45) default NULL, password varchar(15) default NULL, joined_date date default NULL, ipadds varchar(25) default NULL, status varchar(8) default NULL, last_login timestamp(14) NOT NULL, PRIMARY KEY (mem_id) ) TYPE=MyISAM; /*!40000 ALTER TABLE member_details DISABLE KEYS */; # # Dumping data for table 'member_details' # LOCK TABLES member_details WRITE; /*!40000 ALTER TABLE member_details ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'member_earnings' # DROP TABLE IF EXISTS member_earnings; CREATE TABLE member_earnings ( mem_id int(11) NOT NULL default '0', pd_clickthro float(5,2) default '0.00', referral_bonus float(5,2) default '0.00', credits float(5,2) default '0.00', total_debits float(5,2) default '0.00', total_referrals int(4) NOT NULL default '0', pd_clickban float(5,2) default '0.00', PRIMARY KEY (mem_id) ) TYPE=MyISAM; /*!40000 ALTER TABLE member_earnings DISABLE KEYS */; # # Dumping data for table 'member_earnings' # LOCK TABLES member_earnings WRITE; /*!40000 ALTER TABLE member_earnings ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'member_referrals' # DROP TABLE IF EXISTS member_referrals; CREATE TABLE member_referrals ( mem_id int(11) NOT NULL default '0', parent_id int(11) NOT NULL default '0' ) TYPE=MyISAM; /*!40000 ALTER TABLE member_referrals DISABLE KEYS */; # # Dumping data for table 'member_referrals' # LOCK TABLES member_referrals WRITE; /*!40000 ALTER TABLE member_referrals ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'paid_mail' # DROP TABLE IF EXISTS paid_mail; CREATE TABLE paid_mail ( mem_id int(11) default NULL, aff_id varchar(16) default NULL ) TYPE=MyISAM; /*!40000 ALTER TABLE paid_mail DISABLE KEYS */; # # Dumping data for table 'paid_mail' # LOCK TABLES paid_mail WRITE; /*!40000 ALTER TABLE paid_mail ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'pay_banners' # DROP TABLE IF EXISTS pay_banners; CREATE TABLE pay_banners ( banner_id int(4) unsigned NOT NULL auto_increment, user_id varchar(50) NOT NULL default '', type enum('banner','text') NOT NULL default 'banner', banner_name varchar(50) NOT NULL default '', image_url varchar(255) default NULL, link_url varchar(255) NOT NULL default '', image_width int(3) unsigned NOT NULL default '0', image_height int(3) unsigned NOT NULL default '0', text_link longtext, click_amount decimal(9,3) NOT NULL default '0.000', clicks_remaining int(9) unsigned NOT NULL default '0', date_added date NOT NULL default '0000-00-00', total_clicks int(9) unsigned default '0', PRIMARY KEY (banner_id) ) TYPE=MyISAM; /*!40000 ALTER TABLE pay_banners DISABLE KEYS */; # # Dumping data for table 'pay_banners' # LOCK TABLES pay_banners WRITE; /*!40000 ALTER TABLE pay_banners ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'purchase_contact' # DROP TABLE IF EXISTS purchase_contact; CREATE TABLE purchase_contact ( email_id varchar(50) NOT NULL default '', ad_type varchar(30) NOT NULL default '', cost float(11,2) default NULL, info text, agree char(1) default NULL ) TYPE=MyISAM; /*!40000 ALTER TABLE purchase_contact DISABLE KEYS */; # # Dumping data for table 'purchase_contact' # LOCK TABLES purchase_contact WRITE; /*!40000 ALTER TABLE purchase_contact ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'purchase_gold' # DROP TABLE IF EXISTS purchase_gold; CREATE TABLE purchase_gold ( email_id varchar(50) NOT NULL default '', payment varchar(30) NOT NULL default '', info text, agree char(1) default NULL ) TYPE=MyISAM; /*!40000 ALTER TABLE purchase_gold DISABLE KEYS */; # # Dumping data for table 'purchase_gold' # LOCK TABLES purchase_gold WRITE; /*!40000 ALTER TABLE purchase_gold ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'redeem_contact' # DROP TABLE IF EXISTS redeem_contact; CREATE TABLE redeem_contact ( email varchar(50) NOT NULL default '', amt float(11,2) default NULL, PRIMARY KEY (email) ) TYPE=MyISAM; /*!40000 ALTER TABLE redeem_contact DISABLE KEYS */; # # Dumping data for table 'redeem_contact' # LOCK TABLES redeem_contact WRITE; /*!40000 ALTER TABLE redeem_contact ENABLE KEYS */; UNLOCK TABLES; # # Table structure for table 'redempt' # DROP TABLE IF EXISTS redempt; CREATE TABLE redempt ( track_id varchar(30) NOT NULL default '', item varchar(30) default NULL, amt int(11) default NULL, r_desc text ) TYPE=MyISAM; /*!40000 ALTER TABLE redempt DISABLE KEYS */; # # Dumping data for table 'redempt' # LOCK TABLES redempt WRITE; /*!40000 ALTER TABLE redempt ENABLE KEYS */; UNLOCK TABLES;
Bardzo prosze o szybką pomoc co jest przyczyna i co mam robic.
Z gory dziekuje i czekam na odpowiedz
Pozdro
nie masz dostępu do tej bazy danych.
jak to nie mam dostepu, mam dostep bo jak wgrywam np ten kawalek:
CREATE TABLE additional_info (
mem_id int(11) default NULL,
age int(3) default NULL,
gender enum('Male','Female') default NULL,
marital varchar(10) default NULL,
household char(2) default NULL,
childrens char(2) default NULL,
income varchar(7) default NULL,
housestatus varchar(6) default NULL,
learning varchar(15) default NULL,
occupation varchar(6) default NULL,
vehicles varchar(6) default NULL,
creditcard enum('yes','no') default NULL,
spentonline varchar(4) default NULL,
interests text,
html_email enum('yes','no') default NULL
) TYPE=MyISAM;
To mi sie normalnie to dodaje bez bledu ale to nie jest calosc tej tabeli, i normalnie umie sie zalogowac do bazy
usuń wszystkie linijki z LOCK i wtedy wgraj
ok, zrobilem tak i udalo sie zaladowac do bazy, ale jak odpalam skrypt pokazuje mi sie napis:
File Does'nt Exists
Co to oznacza, co mam zrobic aby bylo dobrze ?
prosze o szybka odp z gory dzieki
pozdro czekam
w wolnym tłumaczeniu: Plik nie istnieje. najprawdopodobniej musisz wgrać wszystkie pliki skryptu.
no ale plik jest naserwerze wszystkie pliki wgralem
posprawdzaj w bazie i w plikach konfiguracyjnych czy adresy plików tam się znajdujących są poprawne.
marines - nie moglbys mi zainstalowac tego skryptu, bo ja nie wiem kiedy mi sie to uda zainstalowac a ty bys to zrobil raz dwa i by bylo. bylbym bardzo wdzieczny
może trochę szczegółów?
o jakie szczegoly ci chodzi, chcialbym tylko zebys mi zainstalowal ten skrypt bo bardzo mi na nim zalezy ale nie potrafie tego zainstalowac. Co byś chcial jeszcze wiedziec. moj nr gg: 3800324
po kontakcie na gg problem rozwiązany.