Question about Computers & Internet

1 Answer

My SQL query error:insert into rp_logins(user_id_lg_date) values("323922","2009-07-24") mt SQL error:Table "getyoulaid.rp_logins doesn't exist SQL error code 1146 Date July 24, 2009, 3:04 am file:/index.php action:login ERR this is the error msg I receive every time I attempt to log into the site

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 13,433 Answers

Is this your website and do you have access to the sql server? Do you have a PHP my admin page where you can manage the sql databases or command line access?

in the sql database the rp_logins table doesn't exist, make sure it is there or maybe you have misspelled the table name.

You could run Show tables; and see if you have written the name of the table correctly.

if this doesn't make any sense to you, then you should contact the webmaster of the website your trying to log in to. as you can't fix this as its a problem at the service / server / website and not on your computer.

Posted on Jul 24, 2009

  • Ekse Jul 24, 2009

    Also there is a error on this command:

    insert into rp_logins(user_id_lg_date) values("$userid","$lgdate")

    You have two separate values, user id, 323922 and date your have supplied only one field, User_Id_lg_date, are you sure that this is correct?


    It should be as follows:


    INSERT INTO rp_logins(user_id, lg_date) VALUES('$userid','$lgdate')

    now the 323922 goes to user id and date goes to lg_date. previously it was set that both go into the same field..

    again if this doesn't make any sense to you then contact the web developer of the website or the webmaster or their support about it.




×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

'Table does not exist' error in MySQL, although it really exists


it usually means that no table exists in the default database with the given name. In some cases, it may be that the table does exist but that you are referring to it incorrectly. Maybe your database and table names are case sensitive if they are located on a file system that has case-sensitive file names. Or perhapsall references to a given table within a query must use the same lettercase.
Use SHOW TABLES to check which tables are in the default database.
Well, if you are sure that table is exist and you write its name exactly such it should be, then I suppose something wrong with the database, it can be seriously corrupt. And in this case you need a professional help. This tool must help at any rate - Recovery Toolbox for MySQL https://mysql.recoverytoolbox.com/

Mar 11, 2015 | Oracle MySQL Enterprise Ed 1-4 Socket...

2 Answers

How to Change SQL Server 2005/2008 User Password


There is one SQL password recovery tool, SQL Password Genius, which would help you to successfully change SQL Server 2005/2008/2012 user password instantly, especially when you couldn't think of other ways for it.

1. Open SQL Server Configuration Management and stop SQL Server Services.

2. Install SQL Password Genius full version and run it on computer.

3. Click "Open File" button to import master.mdf database file into this recovery tool.

4. Select user in list and click "Reset" button.
Instantly, new user password would be available for SQL Server logon after you type new password for user.

Now, SQL Server user password has been changed and you can login into SAL server now. But please remember to restart SQL Server Services before you access to SQL Server with user password.

Jul 04, 2014 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

Php counter


You might want to note that this is not the most effective manner of creating a counter in PHP. On a few of my websites, I find it is much more effective to simply create a text file, eg. counter.txt and have PHP read that every time the page is loaded, instead of running a MySQL query. Then, have PHP also update the counter.txt file by adding 1 to the number already listed in the file and read to the user.

Mar 19, 2009 | The PHP Group PHP

1 Answer

After installing DB2 query is not executing


could you check whether you are connected to the database, where you are trying to create table,

check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Hi,

Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

MySQL Auto Increase


Try this -


CREATE TABLE users (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
login TEXT NOT NULL,
password TEXT NOT NULL,
PRIMARY KEY( id )
);

INSERT INTO users VALUES ( null, 'bob', 'mypassword' );
INSERT INTO users VALUES ( null, 'bill', 'pass' );
INSERT INTO users VALUES ( null, 'sean', '1234' );

Aug 04, 2008 | Sun MySQL

1 Answer

SQL


select productid, numberofproduct+2, totalvalue + 1
from
table1, table2
where table1.productid = table2.productid
group by productid

Jul 09, 2008 | Microsoft Computers & Internet

1 Answer

Query for retrieve the data


so, are you looking for the query statement to get this info...

And, upon entering the 6th digit, your code will execute the sql query, such as:
SELECT cardnumber from <table_name> where cardnumber>='123456'

NOTE: replace <table_name> with the name of your table.

You might have to modify the statement depending upon how your calling it.

Check out more info at http://www.w3schools.com/sql/sql_where.asp

Hope this helps.

Jan 25, 2008 | Computers & Internet

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

41 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...