<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">LOL not a problem! That happens to the
best of us. Glad you got it figured out.<br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://www.intoxination.net">http://www.intoxination.net</a>
<a class="moz-txt-link-freetext" href="http://www.hollyit.net">http://www.hollyit.net</a></pre>
On 3/28/2013 5:08 AM, John Tate wrote:<br>
</div>
<blockquote
cite="mid:CAHnfuAvP9PNRMfMUCNWhmgHfTrV51pH6p83oqndNh5fKNHegmw@mail.gmail.com"
type="cite">
<div dir="ltr">I've just realized I've backed up johntate_dropdb
which is my old drupal 6 database, I wanted to back
up johntate_drupal7db
<div><br>
</div>
<div style="">Sorry I've just wasted everyones time!</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, Mar 28, 2013 at 8:03 PM, John
Tate <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:john@johntate.org" target="_blank">john@johntate.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">I forgot to mention I tried update.php at
some point. I just dropped the database, created it, and
executed the SQL backup on it and then created blocked_ips
again.
<div><br>
</div>
<div>Now I get this...</div>
<div>
<h1 style="font-family:'Times New Roman'">Uncaught
exception thrown in session handler.</h1>
<p style="font-size:medium;font-family:'Times New
Roman'">PDOException: SQLSTATE[42S22]: Column not
found: 1054 Unknown column &#039;ssid&#039; in
&#039;where clause&#039;: SELECT 1 AS
expression FROM {sessions} sessions WHERE ( (sid =
:db_condition_placeholder_0) AND (ssid =
:db_condition_placeholder_1) ) FOR UPDATE; Array (
[:db_condition_placeholder_0] =&gt;
xwZt4FqBjh9Hf4T6qAm-1TJrfLHznoC6mXfiOeNbAMU
[:db_condition_placeholder_1] =&gt; ) in
_drupal_session_write() (line 209 of /sites/<a
moz-do-not-send="true"
href="http://johntate.org/includes/session.inc"
target="_blank">johntate.org/includes/session.inc</a>).</p>
</div>
</div>
<div class="gmail_extra">
<div>
<div class="h5"><br>
<br>
<div class="gmail_quote">On Thu, Mar 28, 2013 at 7:14
PM, John Tate <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:john@johntate.org" target="_blank">john@johntate.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">There is stuff in the table cache
on dreamhost, mysqldump isn't working or
something.</div>
<div class="gmail_extra">
<div>
<div><br>
<br>
<div class="gmail_quote">On Thu, Mar 28,
2013 at 7:12 PM, John Tate <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:john@johntate.org"
target="_blank">john@johntate.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex">
<div dir="ltr">There was nothing in
those tables, problem persists.</div>
<div>
<div>
<div class="gmail_extra">
<br>
<br>
<div class="gmail_quote">On Thu,
Mar 28, 2013 at 12:03 PM, Jamie
Holly <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:hovercrafter@earthlink.net"
target="_blank">hovercrafter@earthlink.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div text="#000000"
bgcolor="#FFFFFF">
<div>Truncate all your
cache_ tables and sessions
table. Also, if you're
running APC or any other
op-code cache, I would
disable that temporarily
in php.ini just to rule
out it being something
there.
<div><br>
<pre cols="72">Jamie Holly
<a moz-do-not-send="true" href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a moz-do-not-send="true" href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre>
</div>
<div>
<div> On 3/27/2013 8:32
PM, John Tate wrote:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote type="cite">
<div dir="ltr">I moved
the source with tar
czf, it should have
copied. Though I
just extracted
Drupal 7.21 and
found I get a
completely different
error now...
<div><br>
</div>
<div>[Wed Mar 27
17:30:48 2013]
[error] PHP Fatal
error: Call to
undefined function
field_attach_load()
in /sites/<a
moz-do-not-send="true"
href="http://johntate.org/includes/entity.inc" target="_blank">johntate.org/includes/entity.inc</a>
on line 321<br>
</div>
<div><br>
</div>
<div>I still don't
understand why
this is happening.</div>
</div>
<div
class="gmail_extra"><br>
<br>
<div
class="gmail_quote">On
Thu, Mar 28, 2013
at 11:14 AM, Jamie
Holly <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:hovercrafter@earthlink.net"
target="_blank">hovercrafter@earthlink.net</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div
text="#000000"
bgcolor="#FFFFFF">
<div>I move
sites all the
time with a
full
mysqldump,
including some
that are 3-4gb
in size. <br>
<br>
Are you sure
the full
source code
got copied?
That class is
defined in
includes/database/select.inc
<div><br>
<pre cols="72">Jamie Holly
<a moz-do-not-send="true" href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a moz-do-not-send="true" href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre>
</div>
<div>
<div> On
3/27/2013 8:05
PM, John Tate
wrote:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote
type="cite">
<div dir="ltr">[Wed
Mar 27 16:59:<a
moz-do-not-send="true" href="tel:13%202013" value="+61132013"
target="_blank">13
2013</a>]
[error] PHP
Fatal error:
Class
'SelectQueryExtender'
not found in
/sites/<a
moz-do-not-send="true"
href="http://johntate.org/includes/pager.inc" target="_blank">johntate.org/includes/pager.inc</a>
on line 15<br>
<div><br>
</div>
<div>Now I'm
getting that
error. None of
this makes
sense anymore.
I looked up a
solution and
it says "<span>Conclusion:
when migrating
or restoring a
site, do and
use a full
database
backup,
containing
tables'
creation and
their data."</span></div>
<div><span><br>
</span></div>
<div><span>How
much more full
can you get
than a
mysqldump? It
just makes no
sense. I might
have to start
over.</span></div>
</div>
<div
class="gmail_extra"><br>
<br>
<div
class="gmail_quote">On
Thu, Mar 28,
2013 at 10:37
AM, Jamie
Holly <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:hovercrafter@earthlink.net"
target="_blank">hovercrafter@earthlink.net</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div
text="#000000"
bgcolor="#FFFFFF">
<div>Nope,
it's looking
for the table
(Table
'johntate.blocked_ips'
doesn't
exist). That
table is part
of Drupal
core. It does
the check in
drupal_is_denied
in
bootstrap.inc.
It does check
for a variable
first, but
that isn't a
standard DB
variable.
That's one you
can define via
$conf in
settings.php.<br>
<br>
Not sure why
your other
installation
doesn't have
that table in
there and why
it isn't
throwing an
error, but
that table
must be there
in order for
Drupal to run.
I would just
manually
recreate the
table via the
MySQL command
line or in
PHPMyAdmin:<br>
<br>
<br>
CREATE TABLE
IF NOT EXISTS
`blocked_ips`
(<br>
`iid`
int(10)
unsigned NOT
NULL
AUTO_INCREMENT
COMMENT
'Primary Key:
unique ID for
IP
addresses.',<br>
`ip`
varchar(40)
NOT NULL
DEFAULT ''
COMMENT 'IP
address',<br>
PRIMARY KEY
(`iid`),<br>
KEY
`blocked_ip`
(`ip`)<br>
)
ENGINE=InnoDB
DEFAULT
CHARSET=utf8
COMMENT='Stores
blocked IP
addresses.'
AUTO_INCREMENT=1
;
<div><br>
<br>
<br>
<pre cols="72">Jamie Holly
<a moz-do-not-send="true" href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a moz-do-not-send="true" href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre>
</div>
<div>
<div> On
3/27/2013 7:27
PM, John Tate
wrote:<br>
</div>
</div>
</div>
<div>
<div>
<blockquote
type="cite">
<div dir="ltr">Sorry
I just
realized it's
looking for a
setting called
blocked_ips in
the table
variable, but
it is not
there on the
original
server. The
tables have
copied
exactly,
otherwise
mysqldump
would be what
is at fault.</div>
<div
class="gmail_extra"><br>
<br>
<div
class="gmail_quote">On
Thu, Mar 28,
2013 at 10:19
AM, John Tate
<span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:john@johntate.org" target="_blank">john@johntate.org</a>></span>
wrote:<br>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div dir="ltr">They
all copied
over, I just
checked lists
on both
servers. There
is no
blocked_ips
table on the
original
server. It
should have
had this
problem there.</div>
<div
class="gmail_extra"><br>
<br>
<div
class="gmail_quote">
<div> On Thu,
Mar 28, 2013
at 10:09 AM,
Jamie Holly <span
dir="ltr"><<a
moz-do-not-send="true" href="mailto:hovercrafter@earthlink.net"
target="_blank">hovercrafter@earthlink.net</a>></span>
wrote:<br>
</div>
<blockquote
class="gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex">
<div>
<div
text="#000000"
bgcolor="#FFFFFF">
<div>
<div>PDOException:
SQLSTATE[42S02]:
Base table or
view not
found: 1146
Table
'johntate.blocked_ips'
doesn't exist:
SELECT 1 FROM
{blocked_ips}
WHERE ip =
:ip; Array (
[:ip] =>
220.245.128.9
) in
drupal_is_denied()
(line 1895 of
/sites/<a
moz-do-not-send="true"
href="http://johntate.org/includes/bootstrap.inc" target="_blank">johntate.org/includes/bootstrap.inc</a>).<br>
<br>
</div>
By looks of it
all the tables
didn't copy
over. <br>
<span><font
color="#888888">
<pre cols="72">Jamie Holly
<a moz-do-not-send="true" href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a moz-do-not-send="true" href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre>
</font></span>
<div> On
3/27/2013 6:54
PM, John Tate
wrote:<br>
</div>
</div>
<div>
<blockquote
type="cite">PDOException:
SQLSTATE[42S02]:
Base table or
view not
found: 1146
Table
'johntate.blocked_ips'
doesn't exist:
SELECT 1 FROM
{blocked_ips}
WHERE ip =
:ip; Array (
[:ip] =>
220.245.128.9
) in
drupal_is_denied()
(line 1895 of
/sites/<a
moz-do-not-send="true"
href="http://johntate.org/includes/bootstrap.inc" target="_blank">johntate.org/includes/bootstrap.inc</a>).</blockquote>
<br>
</div>
</div>
<br>
</div>
<span><font
color="#888888">--<br>
[ Drupal
support list |
<a
moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</font></span></blockquote>
</div>
<span><font
color="#888888"><br>
<br
clear="all">
<div><br>
</div>
-- <br>
<a
moz-do-not-send="true"
href="http://www.johntate.org" target="_blank">www.johntate.org</a> </font></span></div>
</blockquote>
</div>
<br>
<br
clear="all">
<div><br>
</div>
-- <br>
<a
moz-do-not-send="true"
href="http://www.johntate.org" target="_blank">www.johntate.org</a> </div>
<br>
<fieldset></fieldset>
<br>
</blockquote>
<br>
</div>
</div>
</div>
<br>
--<br>
[ Drupal
support list |
<a
moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</blockquote>
</div>
<br>
<br
clear="all">
<div><br>
</div>
-- <br>
<a
moz-do-not-send="true"
href="http://www.johntate.org" target="_blank">www.johntate.org</a> </div>
<br>
<fieldset></fieldset>
<br>
</blockquote>
<br>
</div>
</div>
</div>
<br>
--<br>
[ Drupal support
list | <a
moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<a
moz-do-not-send="true"
href="http://www.johntate.org" target="_blank">www.johntate.org</a> </div>
<br>
<fieldset></fieldset>
<br>
</blockquote>
<br>
</div>
</div>
</div>
<br>
--<br>
[ Drupal support list | <a
moz-do-not-send="true"
href="http://lists.drupal.org/"
target="_blank">http://lists.drupal.org/</a>
]<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<a moz-do-not-send="true"
href="http://www.johntate.org"
target="_blank">www.johntate.org</a>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
</div>
</div>
<span><font color="#888888">-- <br>
<a moz-do-not-send="true"
href="http://www.johntate.org"
target="_blank">www.johntate.org</a>
</font></span></div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
</div>
</div>
<span class="HOEnZb"><font color="#888888">-- <br>
<a moz-do-not-send="true"
href="http://www.johntate.org" target="_blank">www.johntate.org</a>
</font></span></div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<a moz-do-not-send="true" href="http://www.johntate.org"
target="_blank">www.johntate.org</a>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</body>
</html>