[URGENT] My website deletes all news

[luciano01]

Guys, when I'm going to post something on my site in the "News Archive" part it posts normally, but if I'm going to edit it only edits the first post made (no matter which one I select, it always goes to the first post), and when i delete some publication it erases all.



Please help me with this, I really need it! Rep ++

 

[Leesne]

I know this community is full of people with great skills but I don't believe mind reading is one of them.
You need to post code.

 

[luciano01]

Sorry for ignorance

Here is index.php and forum.php

GitHub - Luciano0227/otserv

Contribute to Luciano0227/otserv development by creating an account on GitHub.

github.com

 

[oen432]

Find $SQL->fieldName('id') . " = ".(int) $thread['first_post']." LIMIT 1")->fetch();
Change (int) $thread['first_post'] to $post_id
That should fix editing.

 

[luciano01]

nothing, nothing changed: C

 

[luciano01]

Can someone help me?

 

[Discovery]

Take a look on your database - and check if the news are deleted or hide by some status.

 

[luciano01]

news has been deleted
but they keep the same ip, does this have something to do?

 

[Rombadr]

Your id field is not a Primary Key, modify the table structure and set the ID to be a primary key. (you'll have to delete the existing rows or change the id to 1 and 2 or something different)

 

[luciano01]

Sry

 

[Rombadr]

You're only allowed to post in Portuguese in the Portuguese board.
Modify the following query with your table name

 ALTER TABLE table_name MODIFY id int(11) AUTO_INCREMENT PRIMARY KEY

 

[luciano01]

Your id field is not a Primary Key, modify the table structure and set the ID to be a primary key. (you'll have to delete the existing rows or change the id to 1 and 2 or something different)

Could you teach me how to do this: S

 

[Rombadr]

Could you teach me how to do this: S

You're only allowed to post in Portuguese in the Portuguese board.
Modify the following query with your table name

 ALTER TABLE table_name MODIFY id int(11) AUTO_INCREMENT PRIMARY KEY

 

[luciano01]

I used the code and deleted the existing lines, but when I create them again, they return to the same ip = 0

 

[Rombadr]

Remove all the entries in the table and try run this code (replacing the table name):
ALTER TABLE table_name AUTO_INCREMENT=100;

 

[luciano01]

After removing everything, does it look like this?

SELECT * FROM `z_forum` WHERE 1
ALTER TABLE table_name MODIFY id int(11) AUTO_INCREMENT PRIMARY KEY
ALTER TABLE table_name AUTO_INCREMENT=100

Post automatically merged: May 12, 2020

This is my code z_forum

CREATE TABLE `z_forum` (
  `id` int(11) NOT NULL,
  `first_post` int(11) NOT NULL DEFAULT '0',
  `last_post` int(11) NOT NULL DEFAULT '0',
  `section` int(3) NOT NULL DEFAULT '0',
  `replies` int(20) NOT NULL DEFAULT '0',
  `views` int(20) NOT NULL DEFAULT '0',
  `author_aid` int(20) NOT NULL DEFAULT '0',
  `author_guid` int(20) NOT NULL DEFAULT '0',
  `post_text` text NOT NULL,
  `post_topic` varchar(255) NOT NULL,
  `post_smile` tinyint(1) NOT NULL DEFAULT '0',
  `post_date` int(20) NOT NULL DEFAULT '0',
  `last_edit_aid` int(20) NOT NULL DEFAULT '0',
  `edit_date` int(20) NOT NULL DEFAULT '0',
  `post_ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
  `icon_id` int(11) NOT NULL,
  `news_icon` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `z_forum`
--


-- --------------------------------------------------------

 

[Rombadr]

I told you to change the table_name for the table's name, here's the code:

ALTER TABLE z_forum MODIFY id int(11) AUTO_INCREMENT PRIMARY KEY

 

[luciano01]

continues to have the same problem after I run the code

 

[Rombadr]

Which code generates lines 28 through 30?

 

[luciano01]

I think that either the sql or the forum.php, no?

Post automatically merged: May 12, 2020

if I put this NOT NULL DEFAULT '0',

in place of NOT NULL ,?