StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmySQL InnoDB Table doesn't work on 1and1 server, does on localhost
primarykey
Id
9286373
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2012-02-15T00:39:56.537
FavoriteCount
0
LastActivityDate
2012-02-15T05:28:46.683
LastEditDate
2012-02-15T04:22:17.357
LastEditorUserId
738394
OwnerUserId
738394
ParentId
0
PostTypeId
1
Score
0
ViewCount
1365
LastEditorDisplayName
text
Body
EDIT I changed the table to MyISAM, and it worked. Anyone know why InnoDB wouldn't work, and if there's a way to "enable" it? <hr> Basically, I insert a row, am able to reference the new id via $mysqli->insert_id, select the row, translate it into an associative array, and return it. Right after that, in another function, I try to select it and it does not exist. It also does not exist in the database. Update simply does not update, and delete simply does not delete (although when i say $stmt->affected_rows, it returns > 0). One table (news) modifies without a problem, but another table (products), which utilizes the same code (only it has it's own table name and field values) does not. The function is this: <pre><code>function addNews($title, $message) { $mysqli = open_mysqli(); if ($stmt = $mysqli->prepare("INSERT INTO news(title, message) VALUES (?,?)")) { $stmt->bind_param("ss", $title, $message); $stmt->execute(); $stmt->close(); $id = $mysqli->insert_id; if ($stmt = $mysqli->prepare("SELECT * FROM news WHERE id=? LIMIT 1")) { $stmt->bind_param("i", $id); $stmt->execute(); $meta = $stmt->result_metadata(); while ($field = $meta->fetch_field()) { $params[] = &$row[$field->name]; } call_user_func_array(array($stmt, 'bind_result'), $params); while ($stmt->fetch()) { foreach($row as $key => $val) { $c[$key] = $val; } $results[] = $c; } $stmt->close(); $mysqli->close(); if(isset($results) && $results) { return sqlResultObj(true, $results[0]); } else { return sqlErrorObj('No news with id '.$id); } } } else { return sqlErrorObj('Problem adding news.'); } } </code></pre> The only difference between the tables, besides the fields themselves, is that product is an InnoDB Storage Engine and has other tables referencing it as their foreign key, while news is MyISAM, and does not. Like I said, this works perfectly on my local WAMP server (running Apache 2.2.11, PHP 5.3.0, MySQL 5.1.36) but it presents the above problems on my 1and1 server (PHP 5, MySQL 5, and I have the USA 1&1 Beginner Package Linux_WS... not sure which version of Apache or where to find it). Any ideas would be greatly appreciated.
Tags
<php><mysqli><innodb><prepared-statement><myisam>
Title
mySQL InnoDB Table doesn't work on 1and1 server, does on localhost
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USallicarn
UserOwnerUserId
1. USallicarn
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.