hazdo said:

hello mates hope you are doing okay

i have a pannel that it has stream id in millions values due to autoincrement jump
the problem now is when trying to add user agent or any stream prameter it can be added due to high value limit.
anyway to fix this problem and reset autoincrement to low values

Click to expand...

urgodfather said:

easiest way is to back up the stream table as inserts, truncate it and streams_sys, then re-import and mass edit.

more importantly though, if you have reached millions in your stream id's then you obviously have loaded too many playlists over and over. trials or whatever. that is a really bad habit.

Click to expand...

hazdo said:

it is a friend pannel he told me and i noticed a auto increment jump he maybe did somthing wrong impossible to reach that number manually

i did not get this "back up the stream table as inserts" normal backup for table you mean and backup also stream_arguments ??

Click to expand...

hazdo said:

thanks a lot urgodfather.
after i do mass edit to restream them back you mean sorry for that but please clarify more.

so i need to re select servers and params for each stream

i thought in a way to update id for streams and streams_id for both stream_sys and stream_arguments tables but the problem is that streams_id is not uniq for those two tables

Click to expand...

urgodfather said:

nothing needs to be bothered with stream_arguments.

make full backup to be safe.

then make specific backup just for streams.

truncate streams table and stream_sys table.

restore streams backup.

from panel mass edit streams to assign to servers and etc. this will recreate entries in stream_sys.

Click to expand...